为了避免大家犯同样的错误,现将Access的关键字列出来,如果以后在编程中你遇到了同样的错误,请看看是否使用了Access的关键字。
-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