Microsoft KB Archive/281759

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

Article ID: 281759

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft FrontPage 2002 Standard Edition

-



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

Additional query words: prb FP2002 DIW Database wizard comma value

Keywords: kbprb KB281759

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.