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.

ACC2000: Linked FoxPro Icon Appears Dimmed in Converted Database


View products that this article applies to.

This article was previously published under Q200393
Moderate: Requires basic macro, coding, and interoperability skills.

For a Microsoft Access 2002 version of this article, see 290173 (http://support.microsoft.com/kb/290173/EN-US/ ) .

↑ Back to the top


Symptoms

If you convert to Microsoft Access 2000 an Access database created in an earlier version that has a linked Microsoft FoxPro table, 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.

↑ Back to the top


Cause

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

↑ Back to the top


Resolution

  1. In Control Panel, open the ODBC Data Sources (32-bit) tool and add a new ODBC Data Source for your FoxPro table(s) 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 need to choose the table you want.

↑ Back to the top


Status

Access to FoxPro data via 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, access to Microsoft FoxPro data is possible only through the Microsoft Visual FoxPro ODBC driver. Access to FoxPro data through the Microsoft Jet database engine is no longer supported.

↑ Back to the top


More information

Steps to Reproduce Behavior

  1. In Access 2000, open and convert a database created in an earlier version of Access 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 "Symptoms" section of this article.

↑ Back to the top


References

For more information about setting up ODBC data sources, click Microsoft Access Help on the Help menu, type set up ODBC data source in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

↑ Back to the top


Keywords: KB200393, kbprb

↑ Back to the top

Article Info
Article ID : 200393
Revision : 2
Created on : 7/16/2004
Published on : 7/16/2004
Exists online : False
Views : 352