Access保留字&变量名列表

Access保留字&变量名列表，建表时应避免使用这些词汇和符号。

Access 2002/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     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          以及以下标点符号    .    /    *    ;    :    !    #    &    -    ?    "    '    $

Access 2000

-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     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/

• 收藏此页到 IE收藏夹 POCO网摘 [365Key] [ViVi] 百度藏搜 和讯网摘 天极网摘 狐摘 向您的朋友推荐此文章
• 转载请注明来源：文章大全 网址：http://www.itlearner.com/article/
• 文章关键词：access 保留字 变量
• 如意搜索搜索更多内容：Access保留字&变量名列表
• 特别声明： 本站除部分特别声明禁止转载的专稿外的其他文章可以自由转载，但请务必注明出处和原始作者。文章版权归文章原始作者所有。对于被本站转载文章的个人和网站，我们表示深深的谢意。如果本站转载的文章有版权问题请联系我们，我们会尽快予以更正。

• 上一篇文章：微软与Google之争背景透视及结果预测
• 下一篇文章：统计 Google Adsense 点击