Problem refreshing linked tables via Link manager

[qwert62]

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.

 

[RickSpr]

This error means either that a runtime error occurred which Access doesn't recognize, or that a bug in Access is failing to look up the appropriate message.

If the error number is also displayed, you can get the proper error message by entering the following in the Debug Window: ?AccessError(nnn) where 'nnn' is the error number.

Otherwise, I would try deleting all the table links (or at least the ones giving you a problem) and relinking them, then test the Linked Table Manager again. If that doesn't work, I don't know what to suggest.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein