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/

上一个：根据IP跳转到用户所在城市的实现步骤
下一个：ADODB连接access是出现 80004005 错误的解决方法