You may receive a "Syntax error in INSERT INTO statement" error message when you use ADO.NET code to access Office Access 2003


Symptoms


You may receive the following error message when you use Microsoft ADO.NET code to access Microsoft Office Access 2003:
Syntax error in INSERT INTO statement
This problem may occur when you run the Update function that is related to an Access 2003 database. Additionally, you use the OleDbDataAdapter class and the DataSet class.

Cause


This problem may occur if your database table contains column names that use Microsoft Jet 4.0 reserved words.

Resolution


Change the column names in your database table so that you do not use Jet 4.0 reserved words.

For additional information about Jet 4.0 reserved words, click the following article number to view the article in the Microsoft Knowledge Base:

248738 List of reserved words in Jet 4.0

Status


This behavior is by design.