Problems using Link manager

[qwert62]

I am not sure if this is the correct forum for this problem.

I have an access 97 database that has many linked tables (SQL tables). When I try to refersh tables via link manager, I get the following error message:
"Application-defined or object-defined error".

I am able to refesh some of the tables, but not others. Does anybody know what would cause this error? Thanks in advance for any suggestions.

By the way, upgrading to a newer version of Access is not an option.

 

[sfreeman]

qwert62:

Sorry, I cannot dup this problem, the Linked Table Manager works fine for me with Access 2002 relinking SQL tables.

 

[qwert62]

Thanks for the effort. I have never had this problem before either. It has me stumped. My guess is that the problem is in the SQL tables/index/relationships themselves.