UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Reserved Words    
Reserved Words

This page is under consideration for merging with: Reserved Words In Access

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.

Contents

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.

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 13,949 times.  This page was last modified 01:29, 7 February 2012 by Jack Leach. Contributions by Alan Greenwood and TheDBguy  Disclaimers