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.