The following table is a list of reserved words from the following two sources:
A long time ago I combined the words from both links into one table so I thought I'd share it here. This list should serve as a guide as to what NOT to name any variables, fields, controls, or objects in your Microsoft Access database file.
I think the two most common reserved words people may try to use as field or variable names are:
- NAME
- DATE (and related words like TIME, YEAR, DAY, and so on)
Also, the following symbols must not be used as part of a field name or as part of an object name:
/ * : ! # & - ? ; " ' $
Click on the letters below to jump to the first word beginning with that letter:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
| WORD |
Access 2002 and higher |
Jet 4.0 |
| ABSOLUTE |
|
Yes |
| ACTION |
|
Yes |
| ADD |
Yes |
Yes |
| ADMINDB |
|
Yes |
| ALL |
Yes |
Yes |
| ALLOCATE |
|
Yes |
| ALPHANUMERIC |
Yes |
Yes |
| ALTER |
Yes |
Yes |
| AND |
Yes |
Yes |
| ANY |
Yes |
Yes |
| Application |
Yes |
|
| ARE |
|
Yes |
| AS |
Yes |
Yes |
| ASC |
Yes |
Yes |
| ASSERTION |
|
Yes |
| Assistant |
Yes |
|
| AT |
|
Yes |
| AUTHORIZATION |
|
Yes |
| AUTOINCREMENT |
Yes |
Yes |
| AVG |
Yes |
Yes |
| BAND |
|
Yes |
| BEGIN |
|
Yes |
| BETWEEN |
Yes |
Yes |
| BINARY |
Yes |
Yes |
| BIT |
Yes |
Yes |
| BIT_LENGTH |
|
Yes |
| BNOT |
|
Yes |
| BOOLEAN |
Yes |
|
| BOR |
|
Yes |
| BOTH |
|
Yes |
| BXOR |
|
Yes |
| BY |
Yes |
Yes |
| BYTE |
Yes |
Yes |
| CASCADE |
|
Yes |
| CASCADED |
|
Yes |
| CASE |
|
Yes |
| CAST |
|
Yes |
| CATALOG |
|
Yes |
| CHAR |
Yes |
Yes |
| CHAR_LENGTH |
|
Yes |
| CHARACTER |
Yes |
Yes |
| CHARACTER_LENGTH |
|
Yes |
| CHECK |
|
Yes |
| CLOSE |
|
Yes |
| COALESCE |
|
Yes |
| COLLATE |
|
Yes |
| COLLATION |
|
Yes |
| COLUMN |
Yes |
Yes |
| COMMIT |
|
Yes |
| COMP |
|
Yes |
| CompactDatabase |
Yes |
|
| COMPRESSION |
|
Yes |
| CONNECT |
|
Yes |
| CONNECTION |
|
Yes |
| CONSTRAINT |
Yes |
Yes |
| CONSTRAINTS |
|
Yes |
| CONTAINER |
Yes |
Yes |
| CONTINUE |
|
Yes |
| CONVERT |
|
Yes |
| CORRESPONDING |
|
Yes |
| COUNT |
Yes |
Yes |
| COUNTER |
Yes |
Yes |
| CREATE |
Yes |
Yes |
| CreateDatabase |
Yes |
|
| CREATEDB |
|
Yes |
| CreateField |
Yes |
|
| CreateGroup |
Yes |
|
| CreateIndex |
Yes |
|
| CreateObject |
Yes |
|
| CreateProperty |
Yes |
|
| CreateRelation |
Yes |
|
| CreateTableDef |
Yes |
|
| CreateUser |
Yes |
|
| CreateWorkspace |
Yes |
|
| CROSS |
|
Yes |
| CURRENCY |
Yes |
Yes |
| CURRENT |
|
Yes |
| CURRENT_DATE |
|
Yes |
| CURRENT_TIME |
|
Yes |
| CURRENT_TIMESTAMP |
|
Yes |
| CURRENT_USER |
|
Yes |
| CurrentUser |
Yes |
|
| CURSOR |
|
Yes |
| DATABASE |
Yes |
Yes |
| DATE |
Yes |
Yes |
| DATETIME |
Yes |
Yes |
| DAY |
|
Yes |
| DEALLOCATE |
|
Yes |
| DEC |
|
Yes |
| DECIMAL |
|
Yes |
| DECLARE |
|
Yes |
| DEFAULT |
|
Yes |
| DEFERRABLE |
|
Yes |
| DEFERRED |
|
Yes |
| DELETE |
Yes |
Yes |
| DESC |
Yes |
Yes |
| DESCRIBE |
|
Yes |
| Description |
Yes |
|
| DESCRIPTOR |
|
Yes |
| DIAGNOSTICS |
|
Yes |
| DISALLOW |
Yes |
Yes |
| DISCONNECT |
|
Yes |
| DISTINCT |
Yes |
Yes |
| DISTINCTROW |
Yes |
|
| Document |
Yes |
|
| DOMAIN |
|
Yes |
| DOUBLE |
Yes |
Yes |
| DROP |
Yes |
Yes |
| Echo |
Yes |
|
| ELSE |
Yes |
Yes |
| END |
Yes |
Yes |
| END-EXEC |
|
Yes |
| Eqv |
Yes |
|
| Error |
Yes |
|
| ESCAPE |
|
Yes |
| EXCEPT |
|
Yes |
| EXCEPTION |
|
Yes |
| EXCLUSIVECONNECT |
|
Yes |
| EXEC |
|
Yes |
| EXECUTE |
|
Yes |
| EXISTS |
Yes |
Yes |
| Exit |
Yes |
|
| EXTERNAL |
|
Yes |
| EXTRACT |
|
Yes |
| FALSE |
Yes |
Yes |
| FETCH |
|
Yes |
| Field |
Yes |
|
| Fields |
Yes |
|
| FillCache |
Yes |
|
| FIRST |
|
Yes |
| FLOAT |
Yes |
Yes |
| FLOAT |
Yes |
Yes |
| FLOAT |
Yes |
Yes |
| FOR |
|
Yes |
| FOREIGN |
Yes |
Yes |
| Form |
Yes |
|
| Forms |
Yes |
|
| FOUND |
|
Yes |
| FROM |
Yes |
Yes |
| FULL |
Yes |
Yes |
| FUNCTION |
Yes |
|
| GENERAL |
Yes |
Yes |
| GET |
|
Yes |
| GetObject |
Yes |
|
| GetOption |
Yes |
|
| GLOBAL |
|
Yes |
| GO |
|
Yes |
| GOTO |
|
Yes |
| GotoPage |
Yes |
|
| GRANT |
|
Yes |
| GROUP |
Yes |
Yes |
| GROUP BY |
Yes |
|
| GUID |
Yes |
Yes |
| HAVING |
Yes |
Yes |
| HOUR |
|
Yes |
| IDENTITY |
|
Yes |
| Idle |
Yes |
|
| IEEEDOUBLE |
Yes |
Yes |
| IEEESINGLE |
Yes |
Yes |
| If |
Yes |
|
| IGNORE |
Yes |
Yes |
| IMAGE |
|
Yes |
| IMMEDIATE |
|
Yes |
| Imp |
Yes |
|
| IN |
Yes |
Yes |
| INDEX |
|
Yes |
| Indexes |
Yes |
|
| INDICATOR |
|
Yes |
| INHERITABLE |
|
Yes |
| INITIALLY |
|
Yes |
| INNER |
Yes |
Yes |
| INPUT |
|
Yes |
| INSENSITIVE |
|
Yes |
| INSERT |
Yes |
Yes |
| InsertText |
Yes |
|
| INT |
Yes |
Yes |
| INTEGER |
Yes |
Yes |
| INTEGER |
Yes |
Yes |
| INTEGER |
Yes |
Yes |
| INTEGER |
Yes |
Yes |
| INTERSECT |
|
Yes |
| INTERVAL |
|
Yes |
| INTO |
Yes |
Yes |
| IS |
Yes |
Yes |
| ISOLATION |
|
Yes |
| JOIN |
Yes |
Yes |
| KEY |
Yes |
Yes |
| LANGUAGE |
|
Yes |
| LastModified |
Yes |
|
| LEADING |
|
Yes |
| LEFT |
Yes |
Yes |
| LEVEL |
Yes |
Yes |
| Like |
Yes |
|
| LOCAL |
|
Yes |
| LOGICAL |
Yes |
Yes |
| LOGICAL |
Yes |
Yes |
| LONG |
Yes |
|
| LONGBINARY |
Yes |
Yes |
| LONGCHAR |
|
Yes |
| LONGTEXT |
Yes |
Yes |
| Macro |
Yes |
|
| MATCH |
Yes |
Yes |
| Max |
Yes |
|
| MEMO |
Yes |
Yes |
| MIN |
Yes |
Yes |
| MINUTE |
|
Yes |
| Mod |
Yes |
|
| Module |
Yes |
|
| MONEY |
Yes |
Yes |
| MONTH |
|
Yes |
| Move |
Yes |
|
| NAME |
Yes |
|
| NAMES |
|
Yes |
| NATURAL |
|
Yes |
| NCHAR |
|
Yes |
| NewPassword |
Yes |
|
| NEXT |
|
Yes |
| NO |
Yes |
|
| NOT |
Yes |
Yes |
| NOTE |
Yes |
Yes |
| NULL |
Yes |
Yes |
| NUMBER |
Yes |
Yes |
| NUMERIC |
Yes |
Yes |
| OBJECT |
Yes |
Yes |
| OF |
|
Yes |
| OFF |
Yes |
|
| OLEOBJECT |
Yes |
Yes |
| ON |
Yes |
Yes |
| OPEN |
|
Yes |
| OpenRecordset |
Yes |
|
| OPTION |
Yes |
Yes |
| OR |
Yes |
Yes |
| ORDER |
Yes |
|
| Orientation |
Yes |
|
| OUTER |
Yes |
Yes |
| OUTPUT |
|
Yes |
| OVERLAPS |
|
Yes |
| OWNERACCESS |
Yes |
|
| PAD |
|
Yes |
| Parameter |
Yes |
|
| PARAMETERS |
Yes |
|
| PARTIAL |
Yes |
Yes |
| PASSWORD |
|
Yes |
| PERCENT |
Yes |
Yes |
| PIVOT |
Yes |
|
| POSITION |
|
Yes |
| PRECISION |
|
Yes |
| PREPARE |
|
Yes |
| PRIMARY |
Yes |
Yes |
| PRIOR |
|
Yes |
| PRIVILEGES |
|
Yes |
| PROCEDURE |
Yes |
Yes |
| Property |
Yes |
|
| PUBLIC |
|
Yes |
| Queries |
Yes |
|
| Query |
Yes |
|
| Quit |
Yes |
|
| READ |
|
Yes |
| REAL |
Yes |
|
| Recalc |
Yes |
|
| Recordset |
Yes |
|
| REFERENCES |
Yes |
Yes |
| Refresh |
Yes |
|
| RefreshLink |
Yes |
|
| RegisterDatabase |
Yes |
|
| Relation |
Yes |
|
| RELATIVE |
|
Yes |
| Repaint |
Yes |
|
| RepairDatabase |
Yes |
|
| Report |
Yes |
|
| Reports |
Yes |
|
| Requery |
Yes |
|
| RESTRICT |
|
Yes |
| RIGHT |
Yes |
Yes |
| ROLLBACK |
|
Yes |
| ROWS |
|
Yes |
| SCHEMA |
|
Yes |
| SCREEN |
Yes |
|
| SECOND |
|
Yes |
| SECTION |
Yes |
Yes |
| SELECT |
Yes |
Yes |
| SELECTSECURITY |
|
Yes |
| SESSION |
|
Yes |
| SESSION_USER |
|
Yes |
| SET |
Yes |
|
| SetFocus |
Yes |
|
| SetOption |
Yes |
|
| SHORT |
Yes |
Yes |
| SINGLE |
Yes |
Yes |
| SIZE |
|
Yes |
| SMALLINT |
Yes |
|
| SOME |
Yes |
Yes |
| SPACE |
|
Yes |
| SQL |
Yes |
Yes |
| SQLERROR |
|
Yes |
| SQLSTATE |
|
Yes |
| StDev |
Yes |
|
| StDevP |
Yes |
|
| STRING |
Yes |
Yes |
| SUM |
Yes |
Yes |
| SYSTEM_USER |
|
Yes |
| TABLE |
Yes |
Yes |
| TableDef |
Yes |
|
| TableDefs |
Yes |
|
| TableID |
Yes |
|
| TEMPORARY |
|
Yes |
| TEXT |
Yes |
Yes |
| THEN |
|
Yes |
| TIME |
Yes |
|
| TIMESTAMP |
Yes |
Yes |
| TIMEZONE_HOUR |
|
Yes |
| TIMEZONE_MINUTE |
|
Yes |
| TOP |
Yes |
Yes |
| TRAILING |
|
Yes |
| TRANSACTION |
|
Yes |
| TRANSFORM |
Yes |
|
| TRANSLATE |
|
Yes |
| TRANSLATION |
|
Yes |
| TRIM |
|
Yes |
| TRUE |
Yes |
|
| Type |
Yes |
|
| UNION |
Yes |
Yes |
| UNIQUE |
Yes |
|
| UNIQUEIDENTIFIER |
|
Yes |
| UNKNOWN |
|
Yes |
| UPDATE |
Yes |
Yes |
| UPDATEOWNER |
|
Yes |
| UPDATESECURITY |
|
Yes |
| UPPER |
|
Yes |
| USER |
Yes |
Yes |
| USING |
|
Yes |
| VALUE |
Yes |
Yes |
| VALUES |
Yes |
|
| Var |
Yes |
|
| VARBINARY |
Yes |
Yes |
| VARCHAR |
Yes |
Yes |
| VarP |
Yes |
|
| VARYING |
|
Yes |
| VERSION |
Yes |
|
| WHEN |
|
Yes |
| WHERE |
Yes |
Yes |
| WITH |
Yes |
Yes |
| WORK |
|
Yes |
| Workspace |
Yes |
|
| Xor |
Yes |
|
| YEAR |
Yes |
Yes |
| YES |
Yes |
|
| YESNO |
Yes |
|
| ZONE |
|
Yes |
