Appendix D: Microsoft Jet 4.0 ANSI Reserved Words

Microsoft Jet 4.0 provides enhanced support for ANSI 92 keywords. For example, with Microsoft Jet 4.0 you can use the ANSI CREATE PROCEDURE syntax to create a new query. As a result of this support there are a number of new reserved words. If you have table or column names that conflict with one of the reserved words, you will now get a syntax error when referencing it in a query.

ABSOLUTE DECIMAL IS ROWS
ACTION DECLARE ISOLATION SCHEMA
ADD DEFAULT JOIN SCROLL
ALL DEFERRABLE KEY SECOND
ALLOCATE DEFERRED LANGUAGE SECTION
ALTER DELETE LAST SELECT
AND DESCRIBE LEADING SESSION
ANY DESC LEFT SESSION_USER
ARE DESCRIPTOR LEVEL SET
AS DIAGNOSTICS LIKE SIZE
ASC DISCONNECT LOCAL SMALLINT
ASSERTION DISTINCT LOWER SOME
AT DOMAIN MATCH SQL
AUTHORIZATION DOUBLE MAX SQLCODE
AVG DROP MIN SQLERROR
BEGIN ELSE MINUTE SQLSTATE
BETWEEN END MODULE SUBSTRING
BIT END-EXEC MONTH SUM
BIT_LENGTH ESCAPE NAMES SYSTEM_USER
BOTH EXCEPT NATIONAL TABLE
BY EXCEPTION NATURAL TEMPORARY
CASCADE EXEC NCHAR THEN
CASCADED EXECUTE NEXT TIME
CASE EXISTS NO TIMESTAMP
CAST EXTERNAL NOT TIMEZONE_HOUR
CATALOG EXTRACT NULL TIMEZONE_MINUTE
CHAR FALSE NULLIF TO
CHARACTER FETCH NUMERIC TRAILING
CHAR_LENGTH FIRST OCTET_LENGTH TRANSACTION
CHARACTER_LENGTH FLOAT OF TRANSLATE
CHECK FOR ON TRANSLATION
CLOSE FOREIGN ONLY TRIM
COALESCE FOUND OPEN TRUE
COLLATE FROM OPTION UNION
COLLATION FULL OR UNIQUE
COLUMN GET ORDER UNKNOWN
COMMIT GLOBAL OUTER UPDATE
CONNECT GO OUTPUT UPPER
CONNECTION GOTO OVERLAPS USAGE
CONSTRAINT GRANT PARTIAL USER
CONSTRAINTS GROUP POSITION USING
CONTINUE HAVING PRECISION VALUE
CONVERT HOUR PREPARE VALUES
CORRESPONDING IDENTITY PRESERVE VARCHAR
COUNT IMMEDIATE PRIMARY VARYING
CREATE IN PRIOR VIEW
CROSS INDICATOR PRIVILEGES WHEN
CURRENT INITIALLY PROCEDURE WHENEVER
CURRENT_DATE INNER PUBLIC WHERE
CURRENT_TIME INPUT READ WITH
CURRENT_TIMESTAMP INSENSITIVE REAL WORK
CURRENT_USER INSERT REFERENCES WRITE
CURSOR INT RELATIVE YEAR
DATE INTEGER RESTRICT ZONE
DAY INTERSECT REVOKE  
DEALLOCATE INTERVAL RIGHT  
DEC INTO ROLLBACK