I need to link to Foxpro files that reside on my hard drive using Access 2000. The foxpro option is not in my picklist of all file types, so I must use ODBC since a regular DBase does not work.
Everything goes fine and the tables are linked in using the ODBC driver. The table opens and data can be viewed and entered, etc.
But when I go to build a query from the tables I get an error message at runtime like below:
[Microsoft][ODBC Visual FoxPro Driver]cannot open (#171) etc..
Could not find linked table..
I need help pretty bad. Does anyone know what's wrong??