FP2002: Error Message When You Update or Delete Records from CSV (Text) Database

View products that this article applies to.

Symptoms

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

If you are modifying records:

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

If you are deleting records:

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 error messages may vary, depending on the version of the ODBC driver that is being used.

↑ Back to the top

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 which record to update or delete. The text file has no such index; therefore, the only allowable modifications are newly added records, which use the INSERT statement without DELETE or UPDATE statements.

↑ Back to the top

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 Access, and use the Access drivers.

↑ Back to the top