Microsoft KB Archive/311763

= ACC2000: Access Stops Responding When You Open a Linked Visual FoxPro Table =

Article ID: 311763

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition, when used with:
 * Microsoft Windows NT 4.0 Service Pack 6

-



This article was previously published under Q311763



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you open a linked table that was created in Microsoft Visual FoxPro, Access may stop responding if the following conditions are true:
 * You selected a unique index when you linked the table.
 * You linked the table with an Open Database Connectivity (ODBC) data source name (DSN), using the Visual FoxPro ODBC driver.

The same table may open successfully on a computer that runs Microsoft Windows 2000, Microsoft Windows 95, Microsoft Windows 98, or Microsoft Windows 98 Second Edition (SE).



CAUSE
This issue can occur if the unique index that you selected when you linked the table contains duplicate values.



RESOLUTION
To resolve this issue, link the table again but without selecting a unique index. However, note that this method returns a non-updateable recordset when you open the linked table.

Additional query words: prb

Keywords: kbenv kbprb KB311763

-

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

© Microsoft Corporation. All rights reserved.