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.
tmorton
All-Star
56441 Points
9720 Posts
ASPInsiders
Moderator
Inexplicable Syntax Error in INSERT or UPDATE Statement? See this List of Microsoft Jet 4.0 Reser...
Apr 17, 2005 08:14 PM|LINK
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.
ASP.NET/IIS.NET Website Manager, Neudesic