Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


Cause

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

↑ Back to the top


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

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


Keywords: KB892608, kbprb, kbtshoot

↑ Back to the top

Article Info
Article ID : 892608
Revision : 5
Created on : 3/9/2006
Published on : 3/9/2006
Exists online : False
Views : 407