Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

More information

Behavior similar to this has been observed with the following products:
Collapse this tableExpand this table
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.

↑ Back to the top

Keywords: KB285659, kbnofix, kbbug

↑ Back to the top

Article Info
Article ID : 285659
Revision : 3
Created on : 1/29/2007
Published on : 1/29/2007
Exists online : False
Views : 306