ID: Q189220
The information in this article applies to:
When you call the AddNew method, and then call the Update method of a Recordset, the following error is returned:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in INSERT INTO
statement.
This error occurs if the following are true:
For example, a valid INSERT statement would be as follows:
INSERT INTO Table ([field with space]) Values(value)
ADO generates the following code:
INSERT INTO Table (field with space) Values(value)
Here are four possible resolutions:
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.
Additional query words: kbADO150bug kbADO100bug kbADO
Version : WINDOWS:1.5
Platform : WINDOWS
Issue type : kbbug
Last Reviewed: July 13, 1998