|
|
|
 Reserved Words
|
|
Reserved Words
Related Content:
SQL Reserved Words
The list below are words and symbols that should not be used in field, object, and variable names because they are "reserved words." Reserved words have a specific meaning to Microsoft Access and should be avoided in any naming convention. Using them can cause unexpected results and/or hard to track down errors/bugs.
Access 97
| A
ACTION | 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 (7.0, 97)
|
| 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 | OPEN | Open | OpenRecordset | OPTION | OR | ORDER | 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
|
| W
WHERE | WITH | Workspace
|
| X
Xor
|
| Y
Year | YES | YESNO
|
Access 2000
| 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 | OPEN | Open | 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
|
| W
WHERE | WITH | Workspace
|
| X
Xor
|
| Y
Year | YES | YESNO
|
Access 2002 (XP) / Access 2003
| 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 | Open | OPEN | 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
|
| W
WHERE | WITH | Workspace
|
| X
Xor
|
| Y
Year | YES | YESNO
|
Special Characters
Also the following characters are reserved
| / | * | ; | : | ! | # | & | - | ? | " | ' | $
|
Links
You may also want to check Allen Browne's site Here for an updated version of reserved words for more information.
|
