Microsoft KB Archive/290173

= ACC2002: Linked FoxPro Icon Appears Dimmed in a Converted Database =

Article ID: 290173

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q290173



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

For a Microsoft Access 2000 version of this article, see 200393.



SYMPTOMS
If you convert an Access database that has a linked Microsoft FoxPro table to Microsoft Access 2002, the icon of the table appears dimmed. Also, if you try to open the table, you receive the following error message:

Can't find installable ISAM.



CAUSE
The Microsoft FoxPro ISAM driver is no longer included with Microsoft Access.



RESOLUTION

 * 1) In Control Panel, open the ODBC Data Sources (32-bit) tool and add a new ODBC Data Source for your FoxPro tables using the Microsoft Visual FoxPro driver.
 * 2) In Access, delete the linked FoxPro table.
 * 3) On the File menu, click Get External Data, and then click Linked Tables.
 * 4) In the Link dialog box, in the Files of Type box, click ODBC databases.
 * 5) In the Select Data Source dialog box, select your FoxPro data source, and click OK.
 * 6) If you have a free table directory, you must choose the table that you want.



STATUS
Access to FoxPro data by means of the Microsoft Jet database engine was provided in earlier versions of Microsoft Access and earlier versions of the Microsoft Jet database engine. However, with Access 2000 and later, access to Microsoft FoxPro data is possible only through the Microsoft Visual FoxPro ODBC driver. Access to FoxPro data by means of the Microsoft Jet database engine is no longer supported.



Steps to Reproduce the Behavior

 * 1) In Access 2002, open and convert an Access database that has a linked Microsoft FoxPro table.
 * 2) Double-click the icon for the FoxPro table.

Note that you receive the error message mentioned in the &quot;Symptoms&quot; section of this article.

