You are currently offline, waiting for your internet to reconnect

List of reserved words in Access 2000

This article was previously published under Q209187
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 2002 and Access 2003 version of this article, see 286335.
This article lists words and symbols that you should not use in field, object, and variable names because they are "reserved words." Reserved words have a specific meaning to Microsoft Access or to the Microsoft Jet database engine. If you use a reserved word or symbol, you may receive an error such as the following:
The wizard was unable to preview your report, possibly because a table needed by your report is exclusively locked.
For existing objects with names that contain reserved words, you can avoid errors by surrounding the object name with brackets ([ ]).
Because it is not practical to provide a list of all reserved words, such as built-in function names or Microsoft Access user-defined names, please check your product documentation for additional reserved words. Note that if you set a reference to a type library, an object library, or an ActiveX control, that library's reserved words are also reserved words in your database. For example, if you add an ActiveX control to a form, a reference is set, and the names of the objects, methods, and properties of that control become reserved words in your database.

-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				

The following symbols must not be used as part of a field name or as part of an object name:
   .   /    *   :   !   #   &   -   ?   ;    "    '    $				
For more information about reserved words, search the Help Index for "reserved words."
misc event Month

Article ID: 209187 - Last Review: 12/05/2015 11:04:42 - Revision: 7.0

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbinfo KB209187