Access 2000 Odbc Query question

[btamulis]

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?


Bron Tamulis, CPIM
Great Plains Mfg Consultant

 

[SkipVought]

Hi,

I would guess that your SQL Server Tables were LINKED in MS Access. Check to see that these linked tables still are available or not in MS Access. If not, then relink. Then your queries shoudl run.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]