You may receive a "Syntax error in INSERT INTO statement" error message when you use ADO.NET code to access Office Access 2003 (892608)
The information in this article applies to:
- Microsoft ADO.Net 2.0
- Microsoft ADO.NET (included with the .NET Framework 1.1)
- Microsoft Office Access 2003
SYMPTOMSYou 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. CAUSEThis problem may occur if your database table contains
column names that use Microsoft Jet 4.0 reserved words.RESOLUTIONChange 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.
| Modification Type: | Minor | Last Reviewed: | 3/9/2006 |
|---|
| Keywords: | kbtshoot kbprb KB892608 kbAudDeveloper |
|---|
|