List of Microsoft Jet 4.0 reserved words

For a Microsoft Access 2000 version of this article, see 248738 .

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                 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
The following is a list of reserved characters to avoid when choosing identifier names:


. Perod

! Exclamation point

[ ] Brackets

` Grave Accent

Leading space(s)

Non-printable character (ex. a carriage return)




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:
Propiedades

Id. de artículo: 321266 - Última revisión: 21 jul. 2009 - Revisión: 1

Comentarios