Access保留字&变量名列表

Access保留字&变量名列表，建表时应避免使用这些词汇和符号。

Access 2002/2003

-A ????ADD ????ALL ????Alphanumeric ????ALTER ????AND ????ANY ????Application ????AS ????ASC ????Assistant ????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 ????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 ????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 ???????? 以及以下标点符号 ???. ???/ ???* ???; ???: ???! ???# ???& ???- ???? ???" ???' ???$

Access 2000

-A ????ADD ????ALL ????Alphanumeric ????ALTER ????AND ????ANY ????Application ????AS ????ASC ????Assistant ????AUTOINCREMENT ????Avg -B ????BETWEEN ????BINARY ????BIT ????BOOLEAN ????BY ????BYTE -C ????CHAR,?Mod ????MEMO ????Module ????MONEY ????Move -N ????NAME ????NewPassword ????NO ????Not ????NULL ????NUMBER,?NUMERIC -O ????Object ????OLEOBJECT ????OFF ????ON ????OpenRecordset ????OPTION ????OR ????ORDER ????Orientation ????Outer ????OWNERACCESS -P ????Parameter ????PARAMETERS ????Partial ????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 ????SMALLINT ????SOME ????SQL ????StDev,?TIMESTAMP ????TOP ????TRANSFORM ????TRUE ????Type -U ????UNION ????UNIQUE ????UPDATE ????User -V ????VALUE ????VALUES ????Var,?VARCHAR -W ????WHERE ????WITH ????Workspace -X ????Xor -Y ????Year ????YES ????YESNO ???????? 以及以下标点符号 ???. ???/ ???* ???: ???! ???# ???& ???- ???? ???; ???" ???' ???$

参考文档：
http://support.microsoft.com/kb/286335/
http://support.microsoft.com/kb/209187/

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!