List of reserved words in Jet 4.0

This article was previously published under Q248738
This article has been archived. It is offered "as is" and will no longer be updated.
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.
MORE INFORMATION

Reserved Words

A
ABSOLUTE            ACTION              ADD                 ADMINDBALL                 ALLOCATE            ALPHANUMERIC        ALTERAND                 ANY                 ARE                 ASASC                 ASSERTION           AT                  AUTHORIZATIONAUTOINCREMENT       AVG				
B
BAND                BEGIN               BETWEEN             BINARYBIT                 BIT_LENGTH          BNOT                BORBOTH                BXOR                BY                  BYTE				
C
CASCADE             CASCADED            CASE                CASTCATALOG             CHAR                CHARACTER           CHAR_LENGTHCHARACTER_LENGTH    CHECK               CLOSE               COALESCECOLLATE             COLLATION           COLUMN              COMMITCOMP                COMPRESSION         CONNECT             CONNECTIONCONSTRAINT          CONSTRAINTS         CONTAINER           CONTINUECONVERT             CORRESPONDING       COUNT               COUNTERCREATE              CREATEDB            CROSS               CURRENCYCURRENT             CURRENT_DATE        CURRENT_TIME        CURRENT_TIMESTAMPCURRENT_USER        CURSOR				
D
DATABASE            DATE                DATETIME            DAYDEALLOCATE          DEC                 DECIMAL             DECLAREDEFAULT             DEFERRABLE          DEFERRED            DELETEDESC                DESCRIBE            DESCRIPTOR          DIAGNOSTICSDISALLOW            DISCONNECT          DISTINCT            DOMAINDOUBLE              DROP				
E
ELSE                END                 END-EXEC            ESCAPEEXCEPT              EXCEPTION           EXCLUSIVECONNECT    EXECEXECUTE             EXISTS              EXTERNAL            EXTRACT				
F
FALSE               FETCH               FIRST               FLOATFLOAT4              FLOAT8              FOR                 FOREIGNFOUND               FROM                FULL				
G
GENERAL             GET                 GLOBAL              GOGOTO                GRANT               GROUP               GUID				
H
HAVING              HOUR				
I
IDENTITY            IEEEDOUBLE          IEEESINGLE          IGNOREIMAGE               IMMEDIATE           IN                  INDEXINDICATOR           INHERITABLE         INITIALLY           INNERINPUT               INSENSITIVE         INSERT              INTINTEGER             INTEGER1            INTEGER2            INTEGER4INTERSECT           INTERVAL            INTO                ISISOLATION				
J
JOIN				
K
KEY				
L
LANGUAGE            LAST                LEADING             LEFTLEVEL               LIKE                LOCAL               LOGICALLOGICAL1            LONG                LONGBINARY          LONGCHARLONGTEXT            LOWER				
M
MATCH               MAX                 MEMO                MINMINUTE              MODULE              MONEY               MONTH				
N
NAMES               NATIONAL            NATURAL             NCHARNEXT                NO                  NOT                 NOTENULL                NULLIF              NUMBER              NUMERIC				
O
OBJECT              OCTET_LENGTH        OF                  OLEOBJECTON                  ONLY                OPEN                OPTIONOR                  ORDER               OUTER               OUTPUTOVERLAPS            OWNERACCESS				
P
PAD                 PARAMETERS          PARTIAL             PASSWORDPERCENT             PIVOT               POSITION            PRECISIONPREPARE             PRESERVE            PRIMARY             PRIORPRIVILEGES          PROC                PROCEDURE           PUBLIC				
Q
				
R
READ                REAL                REFERENCES          RELATIVERESTRICT            REVOKE              RIGHT               ROLLBACKROWS				
S
SCHEMA              SCROLL              SECOND              SECTIONSELECT              SELECTSCHEMA        SELECTSECURITY      SESSIONSESSION_USER        SET                 SHORT               SINGLESIZE                SMALLINT            SOME                SPACESQL                 SQLCODE             SQLERROR            SQLSTATESTRING              SUBSTRING           SUM                 SYSTEM_USER				
T
TABLE               TABLEID             TEMPORARY           TEXTTHEN                TIME                TIMESTAMP           TIMEZONE_HOURTIMEZONE_MINUTE     TO                  TOP                 TRAILINGTRANSACTION         TRANSFORM           TRANSLATE           TRANSLATIONTRIM                TRUE				
U
UNION               UNIQUE              UNIQUEIDENTIFIER    UNKNOWNUPDATE              UPDATEIDENTITY      UPDATEOWNER         UPDATESECURITYUPPER               USAGE               USER                USING				
V
VALUE               VALUES              VARBINARY           VARCHARVARYING             VIEW				
W
WHEN                WHENEVER            WHERE               WITHWORK                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:
kbdsupport kbgrpvbdb
Properties

Article ID: 248738 - Last Review: 12/05/2015 17:56:32 - Revision: 4.2

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbinfo kbprogramming KB248738
Feedback