为了避免大家犯同样的错误,现将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转载于:https://www.cnblogs.com/chenlhuaf/archive/2008/03/13/1103578.html
相关资源：绝对实用的asp access关键字搜索实例