FOXPRO AND ODBC PROBLEM

keybs

Registered User.
Local time
Today, 19:57
Joined
Aug 16, 2001
Messages
12
[Microsoft][ODBC Visual FoxPro Driver] File does not exist (error 173)

I am using Win2000 Prof and Access 2000. I am trying to link some Visual FoxPro Tables (.dbf) files to my Access database. I can successfully link one table, but if I link another table and try to access it... I get the following error:

[Microsoft][ODBC Visual FoxPro Driver] File does not exist


Is it only possible to link one table?


Thanks,
Brandon
 
Have you created a ODBC data source for the FoxPro database?
 
Apparently not, Is there more to this than:

Go to File->Get External Data-> Link Table->Select ODBC as file type-> Go to Machine Data Sources-> Select Visual FoxPro Table->And then find the directory with my tables in it.

I guess there is more to it than this???
 
Try going to Start => Settings => Control panel => ODBC Data Sources. Click either the User DSN or System DSN tab, then click 'Add'.

You should now have a pop-up box 'Create New Data Source'. Select the Microsoft FoxPro Driver (or Microsoft Visual FoxPro driver)and click 'finish'. You can then type a name and description for the FoxPro DB and browse to find the correct path. Close.

Then, try to link your tables by selecting ODBC Databases () from the 'Files of Type' drop-down in the link-wizard.

I'm not 100% sure, 'cause I've never worked with FoxPro.
 
I think that there might be an issue with conneting to just a table and not an entire database. I am trying to link 2 tables. I can successfully link then but I can only view the first one I open. If I restart access then I can view the other one. I think that the ODBC driver is dedicated to one table at a time or something. Any thoughts?
 

Users who are viewing this thread

Back
Top Bottom