Microsoft KB Archive/248738

= List of reserved words in Jet 4.0 =

Article ID: 248738

Article Last Modified on 8/12/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q248738



For a Microsoft Access 2002 version of this article, see 321266.



For a Microsoft Access 97 or earlier version of this article, see 109312.



SUMMARY
The Microsoft Jet database engine runs in several different modes depending on whether it is called from Microsoft Access, Data Access Objects, the Microsoft OLE DB Provider for Microsoft Jet, or the Microsoft Access ODBC driver. It can be run in either ANSI mode or non-ANSI (traditional) mode.

Each of these modes results in a slightly different set of reserved words. Queries written in one mode may use a reserved word as an identifier and fail in another mode because of this.

This article provides a list of reserved words to avoid when choosing identifier names.



Reserved Words
A ABSOLUTE           ACTION              ADD                 ADMINDB ALL                ALLOCATE            ALPHANUMERIC        ALTER AND                ANY                 ARE                 AS ASC                 ASSERTION           AT                  AUTHORIZATION AUTOINCREMENT      AVG B BAND               BEGIN               BETWEEN             BINARY BIT                BIT_LENGTH          BNOT                BOR BOTH               BXOR                BY                  BYTE C CASCADE            CASCADED            CASE                CAST CATALOG            CHAR                CHARACTER           CHAR_LENGTH CHARACTER_LENGTH   CHECK               CLOSE               COALESCE COLLATE            COLLATION           COLUMN              COMMIT COMP               COMPRESSION         CONNECT             CONNECTION CONSTRAINT         CONSTRAINTS         CONTAINER           CONTINUE CONVERT            CORRESPONDING       COUNT               COUNTER CREATE             CREATEDB            CROSS               CURRENCY CURRENT            CURRENT_DATE        CURRENT_TIME        CURRENT_TIMESTAMP CURRENT_USER       CURSOR D DATABASE           DATE                DATETIME            DAY DEALLOCATE         DEC                 DECIMAL             DECLARE DEFAULT            DEFERRABLE          DEFERRED            DELETE DESC               DESCRIBE            DESCRIPTOR          DIAGNOSTICS DISALLOW           DISCONNECT          DISTINCT            DOMAIN DOUBLE             DROP E ELSE               END                 END-EXEC            ESCAPE EXCEPT             EXCEPTION           EXCLUSIVECONNECT    EXEC EXECUTE            EXISTS              EXTERNAL            EXTRACT F FALSE              FETCH               FIRST               FLOAT FLOAT4             FLOAT8              FOR                 FOREIGN FOUND              FROM                FULL G GENERAL            GET                 GLOBAL              GO GOTO                GRANT               GROUP               GUID H HAVING             HOUR I IDENTITY           IEEEDOUBLE          IEEESINGLE          IGNORE IMAGE              IMMEDIATE           IN                  INDEX INDICATOR          INHERITABLE         INITIALLY           INNER INPUT              INSENSITIVE         INSERT              INT INTEGER            INTEGER1            INTEGER2            INTEGER4 INTERSECT          INTERVAL            INTO                IS ISOLATION J JOIN K KEY L LANGUAGE           LAST                LEADING             LEFT LEVEL              LIKE                LOCAL               LOGICAL LOGICAL1           LONG                LONGBINARY          LONGCHAR LONGTEXT           LOWER M MATCH              MAX                 MEMO                MIN MINUTE             MODULE              MONEY               MONTH N NAMES              NATIONAL            NATURAL             NCHAR NEXT               NO                  NOT                 NOTE NULL               NULLIF              NUMBER              NUMERIC O OBJECT             OCTET_LENGTH        OF                  OLEOBJECT ON                 ONLY                OPEN                OPTION OR                 ORDER               OUTER               OUTPUT OVERLAPS           OWNERACCESS P PAD                PARAMETERS          PARTIAL             PASSWORD PERCENT            PIVOT               POSITION            PRECISION PREPARE            PRESERVE            PRIMARY             PRIOR PRIVILEGES         PROC                PROCEDURE           PUBLIC Q R READ               REAL                REFERENCES          RELATIVE RESTRICT           REVOKE              RIGHT               ROLLBACK ROWS S SCHEMA             SCROLL              SECOND              SECTION SELECT             SELECTSCHEMA        SELECTSECURITY      SESSION SESSION_USER       SET                 SHORT               SINGLE SIZE               SMALLINT            SOME                SPACE SQL                SQLCODE             SQLERROR            SQLSTATE STRING             SUBSTRING           SUM                 SYSTEM_USER T TABLE              TABLEID             TEMPORARY           TEXT THEN               TIME                TIMESTAMP           TIMEZONE_HOUR TIMEZONE_MINUTE    TO                  TOP                 TRAILING TRANSACTION        TRANSFORM           TRANSLATE           TRANSLATION TRIM               TRUE U UNION              UNIQUE              UNIQUEIDENTIFIER    UNKNOWN UPDATE             UPDATEIDENTITY      UPDATEOWNER         UPDATESECURITY UPPER              USAGE               USER                USING V VALUE              VALUES              VARBINARY           VARCHAR VARYING            VIEW W WHEN               WHENEVER            WHERE               WITH WORK               WRITE X Y YEAR               YESNO Z ZONE Starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no longer contains the following Jet components:
 * Microsoft Jet
 * Microsoft Jet OLE DB Provider
 * ODBC Desktop Database Drivers

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

239114 How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine

The MDAC 2.5 Stack and Windows File Protection white paper contains a full list of the components that are shipped with MDAC 2.5, along with a discussion of Windows File Protection. Refer to this white paper for more information about the Jet dynamic-link libraries (DLLs) that are included in MDAC 2.5, which are no longer a part of MDAC 2.6.

For more information about MDAC 2.5 and Windows File Protection, see the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/mdac25.asp

Additional query words: kbdsupport kbgrpvbdb

Keywords: kbinfo kbprogramming KB248738

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.