Access保留字&变量名列表

Access保留字&变量名列表，建表时应避免使用这些词汇和符号。 Access2002/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 GROUPBY 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 以及以下标点符号 . / * : ! # & – ? \” \’ $ Access2000 -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 GROUPBY 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 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 以及以下标点符号 . / * : ! # & – ? \” \’ $转载自： http://support.microsoft.com/kb/286335/ http://support.microsoft.com/kb/209187/