Microsoft KB Archive/90152

= ACC: Paradox Tables, Indexes, and Multiple Connections =

Article ID: 90152

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q90152



Advanced: Requires expert coding, interoperability, and multiuser skills.



SUMMARY
If a Paradox table does not have a primary key, then it cannot be opened twice, even exclusively. This means it cannot be used in more than one place in a query or in code.



MORE INFORMATION
If you attach or link a Paradox table that has no primary key, you cannot add or edit records in the table. If you create a query and add the table twice, you receive the following error:

Operation not supported on a Paradox table with no primary key.

This can be confusing, because you can create the query that accesses the table twice, but if you try to use it, you receive this error. In addition, if anyone tries to get the output column list of the query, the error occurs. To avoid these problems, add a primary key to the Paradox table.

Paradox is manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: index

Keywords: kb3rdparty kberrmsg kbinfo KB90152

-

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

© Microsoft Corporation. All rights reserved.