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

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:If you are deleting records, you may receive an error message that is similar to one of the following:The error messages may vary, depending on the version of the ODBC driver that is being used.

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.

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.

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