MS Access 2000 ODBC - call failed

[bacon333]

I have a fox pro system dsn ODBC connection to some fox pro tables. When I link them, it works the first time and the table shows up. But when I go back in, the tables don't load and access freezes.

When i tried deleting and recreating the odbc connection to the fox pro table, i got a odbc - call failed error.

any ideas?

 

[Bulldog13]

Gonna need more info...

 

[KB]

do you have to enter a password for the databases when you first link them? If so you will need to save that password within the access database. When you perform the linking there should be a check box to save the connection password. If not then we need better error messages.