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.
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.