FP2002: Cannot Insert, Edit, or Delete Records in Paradox Database That Have Been Accessed Through the Database Interface Wizard (285659)


The information in this article applies to:

  • Microsoft FrontPage 2002
This article was previously published under Q285659
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

SYMPTOMS

You cannot use the Database Editor to insert, edit, or delete records in a Paradox database when the records have been accessed through the Database Interface Wizard.

CAUSE

A table cannot be updated by the Paradox ODBC driver when a unique index is not defined on the table. This is not true for an empty table, which can be updated with a single row even if a unique index is not defined on the table.

If a single row is inserted in an empty table that does not have a unique index, a program cannot create a unique index or insert additional data after the single row has been inserted.

WORKAROUND

To work around this issue, create a unique index for the Paradox table that you want to edit. In order to do this, you may need to obtain the Borland Database Engine.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Behavior similar to this has been observed with the following products:
ProductFunctionality or Issue
dBASE IIIUpdate - You must use an updateable query
Delete - Not available
dBASE IVUpdate - You must use an updateable query
Delete - Not available
FoxPro 2.0Update - Not available
Delete - Not available
Microsoft Visual FoxProUpdate - Not available
Delete - Not available
Microsoft Excel 4Insert - Requires READONLY = 0 in ADO custom parameters
Update - Requires READONLY = 0 in ADO custom parameters
Delete - Not available
Microsoft Excel 97Insert - Requires READONLY = 0 in ADO custom parameters
Update - Requires READONLY = 0 in ADO custom parameters
Delete - Not available
Microsoft Excel 2000Insert - Requires READONLY = 0 in ADO custom parameters
Update - Requires READONLY = 0 in ADO custom parameters
Delete - Not available
TextUpdate - Not available
Delete - Not available
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
Modification Type:MajorLast Reviewed:8/6/2002
Keywords:kbbug KB285659
©2002 Microsoft Corporation. All rights reserved.