Article ID: 892608 - Last Review: March 9, 2006 - Revision: 1.4

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

Expand all | Collapse all

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  (http://support.microsoft.com/kb/248738/ ) List of reserved words in Jet 4.0

STATUS

This behavior is by design.

APPLIES TO
  • Microsoft ADO.NET 2.0
  • Microsoft ADO.NET 1.1
  • Microsoft Office Access 2003
Keywords: 
kbtshoot kbprb KB892608
 

Article Translations

 

Related Support Centers