这几天用Access搭建一个在线购物系统时，弄到注册模块就老是调试通不过，数据无法写入预定的User表中，检查了数据连接层类，连接字符串，SQL语句都没什么问题，但就是写不进去……
奇怪的是其他表就能写入，于是从Access中入手，修改User表名为Users后居然能够访问了。
可能Access将User这几个字保留了吧，上网一查果然不出所料，保留的字太挺多，表名绝对不能用这些字。
以下为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 以及以下标点符号 . / * ; : ! # & - ? " ' $
