Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Can't open an ADP file after server rebuild

Can't open an ADP file after server rebuild

Can't open an ADP file after server rebuild

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 ?
Replies continue below

Recommended for you

RE: Can't open an ADP file after server rebuild


Any ideas on how to handle this type problem ?

You'll probably get a better response in one of the specialist Access forums. Not all the Access experts visit here.

Geoff Franklin

RE: Can't open an ADP file after server rebuild

Open your adp and click Cancel when prompted for user name and password (while keeping Shift pressed).

File - Connection

Enter the server IP in the server name box, user name, password, then test the connection.

Then do a search for some hard-coded IP and change it. To do that, open any module, press Ctrl+F, enter the IP or servername (just in case), then search the entire project.

I'm not aware of connection string changes through macros, but who knows... you should check the macros line by line...
And when you have the time change the darn macros to code, you'll get rid of many problems.

Should work...


Daniel Vlas
Systems Consultant


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close