You are currently offline, waiting for your internet to reconnect

Reserved words in Microsoft Access 97

This article was previously published under Q109312
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
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 thathave a specific meaning to Microsoft Access or the Microsoft Jet databaseengine. If you use a reserved word or symbol, you may receive an errorsuch 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 avoiderrors by surrounding the object name with brackets.
These words are reserved in all versions except where noted otherwise.Because it is not practical to provide a list of all reserved words, suchas built-in function names or Microsoft Access user-defined names, pleasecheck your product documentation for additional reserved words. Notethat if you set a reference to a type library, an object library, or anActiveX control, that library's reserved words are also reserved wordsin your database. For example, if you add an ActiveX control to a form,a reference is set and the names of the objects, methods, andproperties 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 (7.0, 97)-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    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 should not be used as part of a field name:
   .   /    *   :   !   #   &   -				
For more information about reserved words, search the Help Index for"reserved words."
misc event

Article ID: 109312 - Last Review: 01/18/2007 23:41:26 - Revision: 3.1

  • Microsoft Access 97 Standard Edition
  • kbinfo KB109312