Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
Glossary

New Entries Added Almost Daily!
Click here to get on our Mailing List

   

   Access    Excel    Word    Windows    HTML

 
MS Access

Reserved Words

A List of Reserved Words

In this tutorial you will learn about the Reserved Words in Access.

I need to compile this list into one but for now here are them separately.

  • Reserved Words in Access 2002 or later
  • Jet 4.0
  • ANSI-92 Reserved Words
  • MS Query

If you are going to use these, which I don't advise, wrap them in square brackets ([]) when using them in a Query etc.


Microsoft have supplied a handy list of Reserved Words in Access 2002 or later.

-A
    ADD
    ALL
    Alphanumeric
    ALTER
    AND
    ANY
    Application
    AS
    ASC
    Assistant
    AUTOINCREMENT
    Avg
-B
    BETWEEN
    BINARY
    BIT
    BOOLEAN
    BY
    BYTE
-C
    CHAR, CHARACTER
    COLUMN
    CompactDatabase
    CONSTRAINT
    Container
    Count
    COUNTER
    CREATE
    CreateDatabase
    CreateField
    CreateGroup
    CreateIndex
    CreateObject
    CreateProperty
    CreateRelation
    CreateTableDef
    CreateUser
    CreateWorkspace
    CURRENCY
    CurrentUser
-D
    DATABASE
    DATE
    DATETIME
    DELETE
    DESC
    Description
    DISALLOW
    DISTINCT
    DISTINCTROW
    Document
    DOUBLE
    DROP
-E
    Echo
    Else
    End
    Eqv
    Error
    EXISTS
    Exit
-F
    FALSE
    Field, Fields
    FillCache
    FLOAT, FLOAT4, FLOAT8
    FOREIGN
    Form, Forms
    FROM
    Full
    FUNCTION
-G
    GENERAL
    GetObject
    GetOption
    GotoPage
    GROUP
    GROUP BY
    GUID
-H
    HAVING
-I
    Idle
    IEEEDOUBLE, IEEESINGLE
    If
    IGNORE
    Imp
    IN
    INDEX
    Index, Indexes
    INNER
    INSERT
    InsertText
    INT, INTEGER, INTEGER1, INTEGER2, INTEGER4
    INTO
    IS
-J
    JOIN
-K
    KEY
-L
    LastModified
    LEFT
    Level
    Like
    LOGICAL, LOGICAL1
    LONG, LONGBINARY, LONGTEXT
-M
    Macro
    Match
    Max, Min, Mod
    MEMO
    Module
    MONEY
    Move
-N
    NAME
    NewPassword
    NO
    Not
    Note
    NULL
    NUMBER, NUMERIC
-O
    Object
    OLEOBJECT
    OFF
    ON
    OpenRecordset
    OPTION
    OR
    ORDER
    Orientation
    Outer
    OWNERACCESS
-P
    Parameter
    PARAMETERS
    Partial
    PERCENT
    PIVOT
    PRIMARY
    PROCEDURE
    Property
-Q
    Queries
    Query
    Quit
-R
    REAL
    Recalc
    Recordset
    REFERENCES
    Refresh
    RefreshLink
    RegisterDatabase
    Relation
    Repaint
    RepairDatabase
    Report
    Reports
    Requery
    RIGHT
-S
    SCREEN
    SECTION
    SELECT
    SET
    SetFocus
    SetOption
    SHORT
    SINGLE
    SMALLINT
    SOME
    SQL
    StDev, StDevP
    STRING
    Sum
-T
    TABLE
    TableDef, TableDefs
    TableID
    TEXT
    TIME, TIMESTAMP
    TOP
    TRANSFORM
    TRUE
    Type
-U
    UNION
    UNIQUE
    UPDATE
    USER
-V
    VALUE
    VALUES
    Var, VarP
    VARBINARY, VARCHAR
    VERSION
-W
    WHERE
    WITH
    Workspace
-X
    Xor
-Y
    Year
    YES
    YESNO
.
/
*
;
:
!
#
&
-
?
"
'
$
%

Another MS Article: List of reserved words in Jet 4.0

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/en-us/library/ms810823.aspx


Another MS Article: ANSI-92 Reserved Words

ABSOLUTE ALLOCATE ARE
AT AUTHOZATION BIT_LENGTH
BOTH CASCADED CAST
CATALOG CHAR_LENGTH CHARACTER_LENGTH
CLOSE COALESCE COLLATE
COLLATION CONNECTION CONTINUE
CORRESPONDING CROSS CURRENT
CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP
CURRENT_USER CURSOR DEALLOCATE
DECLARE DEFERRABLE DEFERRED
DESCRIBE DESCRIPTOR DIAGNOSTICS
DISCONNECT DOMAIN END
END-EXEC ESCAPE EXCEPT
EXCEPTION EXTERNAL EXTRACT
FETCH FOUND FULL
GET GLOBAL GO
GOTO IMMEDIATE INDICATOR
INITIALLY INPUT INSENSITIVE
INTERSECT INTERVAL ISOLATION
LANGUAGE LEADING LOCAL
LOWER MATCH MODULE
NAMES NATURAL NEXT
NULL OCTET_LENGTH OF
ONLY OPEN OVERLAPS
PARTIAL POSITION PREPARE
PRESERVE PRIOR READ
RELATIVE RESTRICT ROWS
SCROLL SECTION SESSION
SESSION_USER SIZE SQL
SQLCODE SQLERROR SQLSTATE
SUBSTRING SYSTEM_USER TEMPORARY
THEN TIMEZONE_HOUR TIMEZONE_MINUTE
TRAILING TRANSACTION TRANSLATE
TRANSLATION UNIQUE UNKNOWN
UPPER USAGE USING
WHEN WHENEVER WRITE
ZONE

Another MS Article: MS Query

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

Alex Hedley (Avatar) By: Alex Hedley


Click here to sign up for more FREE tips

 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP