Reserved Words In Microsoft Access

I've noticed several posts where people were having trouble accessing an Access Database. In the vast majority of these cases, the problem was the use of a Reserved Word as a database field name. The following are links to KB Articles listing Reserved Words for Access 97 and Access 2002:

Access 97: http://support.microsoft.com/kb/q109312/
Access 2002: http://support.microsoft.com/kb/q286335/

If you are having trouble with a SQL Statement, and you are fairly certain there is nothing wrong with your statement, check your field names against this list. Using Reserved Words as field names, while not prohibited, is never a good idea.

For example, if you have a field where you want to put someone's name, "Name" is a Reserved Word. A better choice would be something like "UserName" or "PatientsName"; something that identifies the field but doesn't use a Reserved Word.