Microsoft KB Archive/892608

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

Article ID: 892608

Article Last Modified on 3/9/2006

-

APPLIES TO


 * Microsoft ADO.NET 2.0
 * Microsoft ADO.NET 1.1
 * Microsoft 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.

Keywords: kbtshoot kbprb KB892608

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.