最近在寫一個庫存系統，用的是Access數據庫，其中用到了Access的若干高級功能。以前雖說用過Access，但不過是一些簡單的查詢存儲。這次在用到一些比較復雜的查詢時，出現莫名的錯誤。查了下結構沒問題，后來一想是不是Access的關鍵字沖突的原因。又在網上搜了下，摘錄入下：

access的保留關鍵字。。。。。。
??-A
?????ADD
?????ALL
?????Alphanumeric
?????ALTER
?????AND
?????ANY
?????Application
?????AS
?????ASC
?????Assistant
???????AT
?????AUTOINCREMENT
?????Avg
-B
?????BETWEEN
?????BINARY
?????BIT
?????BOOLEAN
?????BY
?????BYTE
-C
?????CHAR, CHARACTER
?????COLUMN
?????CompactDatabase
?????CONSTRAINT
?????Container
?????Count
?????COUNTER
?????CREATE
?????CreateDatabase
?????CreateField
?????CreateGroup
?????CreateIndex
?????CreateObject
?????CreateProperty
?????CreateRelation
?????CreateTableDef
?????CreateUser
?????CreateWorkspace
?????CURRENCY
?????CurrentUser
-D
?????DATABASE
?????DATE
?????DATETIME
?????DELETE
?????DESC
?????Description
?????DISALLOW
?????DISTINCT
?????DISTINCTROW
?????Document
?????DOUBLE
?????DROP
-E
?????Echo
?????Else
?????End
?????Eqv
?????Error
?????EXISTS
?????Exit
-F
?????FALSE
?????Field, Fields
?????FillCache
?????FLOAT, FLOAT4, FLOAT8
?????FOREIGN
?????Form, Forms
?????FROM
?????Full
?????FUNCTION
-G
?????GENERAL
?????GetObject
?????GetOption
?????GotoPage
?????GROUP
?????GROUP BY
?????GUID
-H
?????HAVING
-I
?????Idle
?????IEEEDOUBLE, IEEESINGLE
?????If
?????IGNORE
?????Imp
?????IN
?????INDEX
?????Index, Indexes
?????INNER
?????INSERT
?????InsertText
?????INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
?????INTO
?????IS
-J
?????JOIN
-K
?????KEY
-L
?????LastModified
?????LEFT
?????Level
?????Like
?????LOGICAL, LOGICAL1
?????LONG, LONGBINARY, LONGTEXT
????????????????
-M
?????Macro
?????Match
?????Max, Min, Mod
?????MEMO
?????Module
?????MONEY
?????Move
-N
?????NAME
?????NewPassword
?????NO
?????Not
?????Note
?????NULL
?????NUMBER, NUMERIC
-O
?????Object
?????OLEOBJECT
?????OFF
?????ON
?????OpenRecordset
?????OPTION
?????OR
?????ORDER
?????Orientation
?????Outer
?????OWNERACCESS
-P
?????Parameter
?????PARAMETERS
?????Partial
???????Password
?????PERCENT
?????PIVOT
?????PRIMARY
?????PROCEDURE
?????Property
-Q
?????Queries
?????Query
?????Quit
-R
?????REAL
?????Recalc
?????Recordset
?????REFERENCES
?????Refresh
?????RefreshLink
?????RegisterDatabase
?????Relation
?????Repaint
?????RepairDatabase
?????Report
?????Reports
?????Requery
?????RIGHT
-S
?????SCREEN
?????SECTION
?????SELECT
?????SET
?????SetFocus
?????SetOption
?????SHORT
?????SINGLE
?????????Size
?????SMALLINT
?????SOME
?????SQL
?????StDev, StDevP
?????STRING
?????Sum
-T
?????TABLE
?????TableDef, TableDefs
?????TableID
?????TEXT
?????TIME, TIMESTAMP
?????TOP
?????TRANSFORM
?????TRUE
?????Type
-U
?????UNION
?????UNIQUE
?????UPDATE
?????USER
-V
?????VALUE
?????VALUES
?????Var, VarP
?????VARBINARY, VARCHAR
-W
?????WHERE
?????WITH
?????Workspace
-X
?????Xor
-Y
?????Year
?????YES
?????YESNO

與50位技術專家面對面20年技術見證，附贈技術全景圖

總結

以上是生活随笔為你收集整理的Access保留关键字的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。