Select the product you need help with

List of Microsoft Jet 4.0 reserved words

Article ID: 321266 - View products that this article applies to.

This article was previously published under Q321266

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

(http://support.microsoft.com/kb/248738/EN-US/ )

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.

Back to the top | Give Feedback

MORE INFORMATION

Reserved Words

ABSOLUTE            ACTION              ADD                 ADMINDB
ALL                 ALLOCATE            ALPHANUMERIC        ALTER
AND                 ANY                 ARE                 AS
ASC                 ASSERTION           AT                  AUTHORIZATION
AUTOINCREMENT       AVG

BAND                BEGIN               BETWEEN             BINARY
BIT                 BIT_LENGTH          BNOT                BOR
BOTH                BXOR                BY                  BYTE

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

DATABASE            DATE                DATETIME            DAY
DEALLOCATE          DEC                 DECIMAL             DECLARE
DEFAULT             DEFERRABLE          DEFERRED            DELETE
DESC                DESCRIBE            DESCRIPTOR          DIAGNOSTICS
DISALLOW            DISCONNECT          DISTINCT            DOMAIN
DOUBLE              DROP

ELSE                END                 END-EXEC            ESCAPE
EXCEPT              EXCEPTION           EXCLUSIVECONNECT    EXEC
EXECUTE             EXISTS              EXTERNAL            EXTRACT

FALSE               FETCH               FIRST               FLOAT
FLOAT4              FLOAT8              FOR                 FOREIGN
FOUND               FROM                FULL

GENERAL             GET                 GLOBAL              GO
GOTO                GRANT               GROUP               GUID

HAVING              HOUR

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

JOIN

KEY

LANGUAGE            LAST                LEADING             LEFT
LEVEL               LIKE                LOCAL               LOGICAL
LOGICAL1            LONG                LONGBINARY          LONGCHAR
LONGTEXT            LOWER

MATCH               MAX                 MEMO                MIN
MINUTE              MODULE              MONEY               MONTH

NAMES               NATIONAL            NATURAL             NCHAR
NEXT                NO                  NOT                 NOTE
NULL                NULLIF              NUMBER              NUMERIC

OBJECT              OCTET_LENGTH        OF                  OLEOBJECT
ON                  ONLY                OPEN                OPTION
OR                  ORDER               OUTER               OUTPUT
OVERLAPS            OWNERACCESS

PAD                 PARAMETERS          PARTIAL             PASSWORD
PERCENT             PIVOT               POSITION            PRECISION
PREPARE             PRESERVE            PRIMARY             PRIOR
PRIVILEGES          PROC                PROCEDURE           PUBLIC

READ                REAL                REFERENCES          RELATIVE
RESTRICT            REVOKE              RIGHT               ROLLBACK
ROWS

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

TABLE               TABLEID             TEMPORARY           TEXT
THEN                TIME                TIMESTAMP           TIMEZONE_HOUR
TIMEZONE_MINUTE     TO                  TOP                 TRAILING
TRANSACTION         TRANSFORM           TRANSLATE           TRANSLATION
TRIM                TRUE

UNION               UNIQUE              UNIQUEIDENTIFIER    UNKNOWN
UPDATE              UPDATEIDENTITY      UPDATEOWNER         UPDATESECURITY
UPPER               USAGE               USER                USING

VALUE               VALUES              VARBINARY           VARCHAR
VARYING             VIEW

WHEN                WHENEVER            WHERE               WITH
WORK                WRITE

YEAR                YESNO

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

(http://support.microsoft.com/kb/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/en-us/library/ms810823.aspx

(http://msdn.microsoft.com/en-us/library/ms810823.aspx)

Back to the top | Give Feedback