ACC2000: Error Occurs When You Try to Use Multiple Instances of a Linked Paradox Table (209795)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209795
This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

Whether you open a Microsoft Access database in Exclusive mode or Shared mode, you cannot open or access multiple instances of a linked Paradox table. When you try to do so, you may receive the following error message:
Operation not supported on a Paradox table with no primary key.
When you click OK, you may receive the following additional message:
Microsoft Access can't open the table in Datasheet view.

RESOLUTION

Add a primary key to the Paradox table in Paradox.

MORE INFORMATION

If a Paradox table without a unique identifier is linked to an Access database, you cannot add or edit records in the table.

Also, when a linked Paradox table does not have a primary key, you cannot open multiple instances within an Access database. This is true no matter how the Access database has been opened (Exclusive or Shared). For example, if you have a form that is based on the linked Paradox table open in Form view, and you try to open the source Paradox table or open a recordset against the table, you receive the error message mentioned in the "Symptoms" section.

Steps to Reproduce Behavior

  1. Open any Access 2000 database.
  2. On the File menu, point to Get External Data, and then click Link Tables.
  3. In the Files of type box, click Paradox (*.db).
  4. In the Look in box in the Link dialog box, locate the folder where the non-primary key Paradox file is stored.
  5. Click the Paradox file, and then click Link.
  6. Click OK to the message that indicates that the link was successful, and then click Close in the Link dialog box.
  7. With the Paradox table selected in the Database window, on the Insert menu, click AutoForm to create a new form that is based on the linked Paradox table.
  8. With the newly created form open, try to open the same linked Paradox table in Datasheet view. Note that you receive the error message mentioned in the "Symptoms" section.
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.

REFERENCES

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

230126 ACC2000: Using Paradox Data with Access 2000 and Jet

Modification Type:MajorLast Reviewed:6/28/2004
Keywords:kb3rdparty kberrmsg kbprb KB209795
©2004 Microsoft Corporation. All rights reserved.