You receive a 0x80004005 error message when you update or delete records from a CSV database in FrontPage 2003 (828892)

SYMPTOMS

When you try to update or to delete records from a database that was created from a CSV (text) document in Microsoft Office FrontPage 2003, you may receive one of the following error messages.

If you are modifying records, you may receive an error message that is similar to one of the following:

Database Results Error
Description: [Microsoft][ODBC Text Driver] Updating data in a linked table is not supported by this ISAM.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB provider for ODBC Drivers

The operation failed. If this continues, please contact your server administrator.

If you are deleting records, you may receive an error message that is similar to one of the following:

Database Results Error
Description: [Microsoft][ODBC Text Driver] Deleting data in a linked table is not supported by this ISAM.
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB provider for ODBC Drivers

The operation failed. If this continues, please contact your server administrator.

The error messages may vary, depending on the version of the ODBC driver that is being used.

CAUSE

This behavior occurs because ODBC drivers do not allow for the SQL statements UPDATE and DELETE.

The ODBC text file driver does not support DELETE and UPDATE statements, because ODBC depends on a unique key index to determine the record to update or to delete. The text file has no such index; therefore, the only permitted modifications are newly added records that use the INSERT statement without DELETE or UPDATE statements.

WORKAROUND

To work around this behavior, do not use a text file for the database when you use the Database Interface Wizard. Import the text file into Microsoft Access, and then use the Access drivers.

For more information about how to import a text file into Access, click Microsoft Office Access 2003 Help on the Help menu, type Import or link data and objects in the Search for box in the Assistance pane, and then click Start searching to view the topic.

MORE INFORMATION

For additional information about statements supported by ODBC, click the following article number to view the article in the Microsoft Knowledge Base:

146220 PRB: The ODBC text file driver only supports INSERT statement