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



The information in this article applies to:

  • Microsoft FrontPage 2002

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.

MORE INFORMATION

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

146220 PRB: The ODBC Text File Driver Only Supports INSERT Statement


Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb KB281759