ODBC connection error - Queries

[diggermf]

Hi All,

When I'm trying to click on the remote tables in my MS-ACCSESS application it was giving the ODBC connection error and I could able to resolve by going to TOOLS-> DATABASE Utilities -> LINKED TABLE MANAGER and refreshed by providing with userid and changed password.

Its now connecting to tables

But, when I'm clicking on queries its shwoing the same error as ODBC CONNECTION error. I see that the userid and password is been provided correctly and tables are working fine, but I'm not sure why its showing the error message with the queries.

Could some one please advice.

 

[KirbyWallace]

If you open those queries in Design View, and open Properties (view->properties), there are two properties that you might be interested in checking:

Source Database, and Source Connect String.

Just a starting point...