here's a good one!!

[AndyApp]

Ok,

so recently someone in work found an old access 97 database that looks at data on a SQL server that doesn't exist anymore.

They now want to start using the database again but i can't open it because the server that it gets the data from doesn't exist! It gives me an ODBC call error.

Anyone any ideas?

"Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[MasterPO]

If it's an mdb file and if the code that is attmepting to connect to the SQL Server is running when the mdb opens, just open it in design view (hold <Shift> key while opening the mdb file.) This will allow you to relink tables or address any code or macros that are calling the connection on startup.