We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Unable to link VFP tables in Access

richifever
richifever asked
on
Medium Priority
331 Views
Last Modified: 2008-02-01
Hello,

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.
Comment
Watch Question

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
http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.