H.2. Reserved Words
The following terms should be in the list.
H.2.1. Omitted Reserved Words from "SQL Reserved Words" Topic
CONTAINS FROM Clause INSERT INTO SMALLDATETIME SMALLMONEY SYSNAME
H.2.2. Omitted Reserved Words from KB Article Q286335 (http://support.microsoft.com/?id=286335)
Application CompactDatabase CreateDatabase CreateField CreateGroup CreateIndex CreateObject CreateProperty CreateRelation CreateTableDef CreateUser CreateWorkspace CurrentUser Description Document Echo Eqv Error Exit Field, Fields FillCache Form, Forms FUNCTION Idle If Indexes InsertText LastModified Macro Move NAME NewPassword OFF OpenRecordset Parameter Property Queries Query Quit
Recale Recordset Refresh RefreshLink RegisterDatabase Relation Repaint RepairDatabase Report Reports Requery SCREEN SetFocus SetOption TableDef, TableDefs Type Workspace YES
Reserved Words | |
---|---|
ABSOLUTE | AUTOINCREMENT |
ACTION | AVG |
ADD | BAND |
ADMINDB | BEGIN |
ALL | Between |
ALLOCATE | BINARY |
Alphanumeric | BIT |
ALTER | BIT_LENGTH |
ALTER Table | BNOT |
And | BOOLEAN |
ANY | BOR |
Application | BOTH |
ARE | BXOR |
AS | BY |
ASC | BYTE |
ASSERTION | CASCADE |
AT | CASCADED |
AUTHORIZATION | CASE |
CAST | CreateDatabase |
CATALOG | CREATEDB |
CHAR | CreateField |
CHAR_LENGTH | CreateGroup |
CHARACTER | CreateIndex |
CHARACTER_LENGTH | CreateObject |
CHECK | CreateProperty |
CLOSE | CreateRelation |
CLUSTERED | CreateTableDef |
COALESCE | CreateUser |
COLLATE | CreateWorkspace |
COLLATION | CROSS |
COLUMN | CURRENCY |
COMMIT | CURRENT |
COMP | CURRENT_DATE |
CompactDatabase | CURRENT_TIME |
COMPRESSION | CURRENT_TIMESTAMP |
CONNECT | CURRENT_USER |
CONNECTION | CurrentUser |
CONSTRAINT | CURSOR |
CONSTRAINTS | DATABASE |
CONTAINER | DATE |
CONTAINS ... |
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.