FP2002: Error Message When You Update or Delete Records from CSV (Text) Database (281759)
The information in this article applies to:
This article was previously published under Q281759 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.
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.
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.
Modification Type: | Minor | Last Reviewed: | 7/15/2004 |
---|
Keywords: | kbprb KB281759 |
---|
|