Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Can't open an ADP file

Author  Topic 

hornet_4204
Starting Member

1 Post

Posted - 2006-07-05 : 03:52:21
Server crashed and the IP's for all PC's were changed.
Using acces as a front end for the SQL DB (ADP file)with the msde 2000 engine
Restored the SQL files to the orignal location as well as the ADP file
When trying to open up the ADP file get an error that the file can't be found - error connecting to server 192.168.x.x (Old IP scheme)

I have tried configuring a PC with the old IP's and still get the same error.

It appears that macros are being run at start pointing to the old server but when trying to edit the file can't save it as it as the old server can't be found :(

Any ideas on how to handle this type problem ?

   

- Advertisement -