forbidden field names

[w_r_fox]

I named a field "page". This caused problems, since "page" is apparently a
reserved word having a special meaning in Access. I renamed my field
"page_number" and avoided the problems. Where can I find a list of other
such forbidden field names, please.

 

[Cheryl Fischer]

Reserved Words in Access 2000:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

Reserved Words in Access 2002:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

Reserved Words in Access 97 and earlier versions:
http://support.microsoft.com/default.aspx?scid=kb;en-us;109312

hth,

 

[w_r_fox]

Thank you, just what I wanted.

Reserved Words in Access 2000:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209187

Reserved Words in Access 2002:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

Reserved Words in Access 97 and earlier versions:
http://support.microsoft.com/default.aspx?scid=kb;en-us;109312

hth,

 

[Van T. Dinh]

One technique I use is create Table / Field names from an
*abbreviated combinations of 2 or more words* which will
almost always be different from all the reserved words in
Access / JET. Note that some Property Names in Access are
made up of 2 or more words but they are usually spelt ou
in full and therefore also different from my abbreviated
combinations.

HTH
Van T. Dinh
MVP (Access)