Access 2000 change ODBC query

[btamulis]

Greetings - first time poster.



I have several Access(2000) Queries created that are querying data from a SQL database.

I inherited these queries and everything was working fine. We recently changed our SQL server and our IT person deleted the old ODBC connection and created a new one to the new SQL server.

Now my queries do not work.......they see data but it's data from the old server (which is still running) and not the new server.

I work alot with Crystal Reports and it's very easy to 'change' database location. However, in Access I can't seem to find a location/screen where i could edit the connection string associated with the Query......

I'm very new to access..........this has to be an easy fix right?

[pbaldy]

If you're using linked tables, you'd go into

Tools/Database Utilities/Linked Table Manager

Check the applicable tables, check the box that says "Always check for new location" and click OK.