Unable to link VFP tables in Access

Posted on 2007-07-19
Last Modified: 2008-02-01

I am linking FOXPRO tables into MS Access 2003 using the Microsoft Visual FoxPro ODBC Driver.  These tables are from another program that has a new version out.  In the old version, I would link the tables using the free tables method and it worked fine.  In the new version, if I link the tables using free tables, a lot of the key tables would not appear.  I found this solution here:

So I followed the solution at the mentioned link which stated to use the .DBC file instead of using the free tables method.  I am now able to "see" the key tables listed in the combo box for choosing to link.  After selecting the appropriate tables, I get an error stating:

Could not execute query; could not find linked table.
[Microsoft][ODBC Visual FoxPro Driver] Not a table. (#123)

Thank you for your help in advance.
Question by:richifever
    LVL 33

    Accepted Solution

    If the new Visual FoxPro version is past VFP6, then there are probably features that the ODBC driver will not fully support.  To get to all of the features, you may need to use the OLE DB Provider for VFP rather than the older ODBC driver that only supports VFP versions through VFP6 fully.  In Access, I'm told you use the same methodology except you must choose an "Advanced" push button to get to the OLE DB Providers.

    Microsoft OLE DB Provider for Visual FoxPro (through) 9.0

    Author Comment

    I think after hours of search, that is what seems to be the case.  So now i need to find this "Advanced" push button.  Thank you.
    LVL 33

    Expert Comment

    As far as that button, I see in MS Word that it is not a button at all but a choice that reads "Other/Advanced" below a list of other items, including a ODBC DSN one, as part of the Data Connection Wizard.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now