Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Unable to link VFP tables in Access


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: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21342885.html

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.
  • 2
1 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
richifeverAuthor Commented:
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.
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now