Thank you to
imagemaker for pointing out
KB article 321266, which contains the list of reserved words for Microsoft Jet 4.0.
If you see an inexplicable "syntax error" message when trying to
execute a SQL statement, a reserved word is the first place to
look. If you find that you have used any of these reserved words
for column names, you will need to enclose the column name in square
brackets whenever you use it in an a query.
Password and User are two reserved words that seem to be frequently used as column names.
Terri Morton
Program Manager, Telligent
How to ask a question