ACC: Reserved Words in Microsoft Access

ID: Q109312


The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97


SUMMARY

Novice: Requires knowledge of the user interface on single-user computers.

This article lists words and symbols that should be avoided in field, object, and variable names because they are "reserved words," words that have a specific meaning to Microsoft Access or 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.


MORE INFORMATION

These words are reserved in all versions except where noted otherwise. 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 (2.0, 7.0, 97)
    Alphanumeric
    ALTER
    AND
    ANY (2.0, 7.0, 97)
    Application
    AS
    ASC
    Assistant
    AUTOINCREMENT
    Avg
-B
    BETWEEN
    BINARY
    BIT
    BOOLEAN
    BY
    BYTE
-C
    CHAR, CHARACTER
    COLUMN
    CompactDatabase (2.0, 7.0, 97)
    CONSTRAINT
    Container  (2.0, 7.0, 97)
    Count
    COUNTER (2.0, 7.0, 97)
    CREATE
    CreateDatabase  (2.0, 7.0, 97)
    CreateField (2.0, 7.0, 97)
    CreateGroup (2.0, 7.0, 97)
    CreateIndex (2.0, 7.0, 97)
    CreateObject  (2.0, 7.0, 97)
    CreateProperty (2.0, 7.0, 97)
    CreateRelation (2.0, 7.0, 97)
    CreateTableDef (2.0, 7.0, 97)
    CreateUser (2.0, 7.0, 97)
    CreateWorkspace (2.0, 7.0, 97)
    CURRENCY
    CurrentUser (2.0, 7.0, 97)
-D
    DATABASE (2.0, 7.0, 97)
    DATE (2.0, 7.0, 97)
    DATETIME
    DELETE
    DESC
    Description
    DISALLOW
    DISTINCT
    DISTINCTROW
    Document (2.0, 7.0, 97)
    DOUBLE (2.0, 7.0, 97)
    DROP
-E
    Echo (2.0, 7.0, 97)
    Else
    End
    Eqv
    Error
    EXISTS (2.0, 7.0, 97)
    Exit
-F
    FALSE
    Field, Fields (2.0, 7.0, 97)
    FillCache (2.0, 7.0, 97)
    FLOAT, FLOAT4, FLOAT8
    FOREIGN (2.0, 7.0, 97)
    Form, Forms
    FROM
    Full (2.0, 7.0, 97)
    FUNCTION
-G
    GENERAL
    GetObject (2.0, 7.0, 97)
    GetOption (2.0, 7.0, 97)
    GotoPage
    GROUP  (2.0, 7.0, 97)
    GROUP BY
    GUID (7.0, 97)
-H
    HAVING
-I
    Idle (2.0, 7.0, 97)
    IEEEDOUBLE, IEEESINGLE
    If
    IGNORE (2.0, 7.0, 97)
    Imp
    IN, In
    INDEX
    Index, Indexes (2.0, 7.0, 97)
    INNER
    INSERT
    InsertText (2.0, 7.0, 97)
    INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
    INTO
    IS, Is
-J
    JOIN
-K
    KEY (2.0, 7.0, 97)
-L
    LEFT
    Level
    Like
    LOGICAL, LOGICAL1
    LONG, LONGBINARY, LONGTEXT
-M
    Match (2.0, 7.0, 97)
    Max, Min, Mod
    MEMO
    MONEY
    Move (2.0, 7.0, 97)
-N
    NAME (2.0, 7.0, 97)
    NewPassword (2.0, 7.0, 97)
    NO
    Not
    NULL
    NUMBER, NUMERIC
-O
    Object (2.0, 7.0, 97)
    OLEOBJECT (2.0, 7.0, 97)
    OFF
    ON
    OpenRecordset (2.0, 7.0, 97)
    OPTION
    OR, Or
    ORDER
    Outer (2.0, 7.0, 97)
    OWNERACCESS
-P
    Parameter (2.0, 7.0, 97)
    PARAMETERS
    Partial (2.0, 7.0, 97)
    PERCENT (2.0, 7.0, 97)
    PIVOT
    PRIMARY
    PROCEDURE
    Property (2.0, 7.0, 97)
-Q
    Quit (2.0, 7.0, 97)
-R
    REAL
    Recalc (2.0, 7.0, 97)
    Recordset (2.0, 7.0, 97)
    REFERENCES
    Refresh
    RefreshLink (2.0, 7.0, 97)
    RegisterDatabase (2.0, 7.0, 97)
    Relation (2.0, 7.0, 97)
    Repaint (2.0, 7.0, 97)
    RepairDatabase (2.0, 7.0, 97)
    Reports
    Requery
    RIGHT
-S
    SCREEN
    SECTION
    SELECT (2.0, 7.0, 97)
    SET
    SetFocus (2.0, 7.0, 97)
    SetOption (2.0, 7.0, 97)
    SHORT
    SINGLE (2.0, 7.0, 97)
    SMALLINT (2.0, 7.0, 97)
    SOME (2.0, 7.0, 97)
    SQL
    StDev, StDevP
    STRING
    Sum
-T
    TABLE
    TableDef, TableDefs (2.0, 7.0, 97)
    TableID
    TEXT
    TIME, TIMESTAMP (2.0, 7.0, 97)
    TOP (2.0, 7.0, 97)
    TRANSFORM
    TRUE
-U
    UNION
    UNIQUE
    UPDATE
-V
    VALUE
    VALUES (2.0, 7.0, 97)
    Var, VarP
    VARBINARY, VARCHAR (2.0, 7.0, 97)
-W
    WHERE
    WITH
    Workspace (2.0, 7.0, 97)
-X
    Xor
-Y
    YES
    YESNO (2.0, 7.0, 97) 

The following symbols should not be used as part of a field name:

   .
   / 
   *
   :
   !
   #
   &
   - 


REFERENCES

For more information about reserved words, search the Help Index for "reserved words."

Additional query words: misc event

Keywords : TblFldp
Version : WINDOWS:1.0,1.1,2.0,7.0,97
Platform : WINDOWS
Issue type : kbinfo


Last Reviewed: March 30, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.