今天运行一段程序，总是报“运行时错误（之后一串数字），From子句语法错误”。我跟进去，把sql的值拷出来，贴在Access的查询设计器sql模式里，没错。同样的函数、同样的sql，只是表名加了“[]”，也没错。我有点小郁闷。
然后上网看了下，有两个网友也遇到过类似的情况，最后都发现是From之后的表名和Access的保留字冲突，加了[]之后就没事了，我也这么试试，一切OK。呵呵。
-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
