Microsoft KB Archive/285659

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

Article ID: 285659

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft FrontPage 2002 Standard Edition

-



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:

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.

Keywords: kbbug kbnofix KB285659

-

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

© Microsoft Corporation. All rights reserved.