Changing ADP SQL Connection when SQL Server is dead

  • Thread starter Thread starter Kyle Jedrusiak
  • Start date Start date
K

Kyle Jedrusiak

How can I change the server connection in an Access ADP file if the original
server is dead?

The ADP file will not open.

[I'm using Access 2002 - Office XP]

Kyle!
 
The ADP should open Disconnected. You can then go to File Connection and
specify the new server.

Does it not open at all?

Adam
 
This is the error...

"File C:\....\xxx.adp" or one of it's components can't be found"

Kyle

Adam Pedder said:
The ADP should open Disconnected. You can then go to File Connection and
specify the new server.

Does it not open at all?

Adam

message news:[email protected]...
How can I change the server connection in an Access ADP file if the original
server is dead?

The ADP file will not open.

[I'm using Access 2002 - Office XP]

Kyle!
Click to expand...
Click to expand...
 
To answer the question...no it doesn't open and ask me to re-connect.

Kyle


Adam Pedder said:
The ADP should open Disconnected. You can then go to File Connection and
specify the new server.

Does it not open at all?

Adam

message news:[email protected]...
How can I change the server connection in an Access ADP file if the original
server is dead?

The ADP file will not open.

[I'm using Access 2002 - Office XP]

Kyle!
Click to expand...
Click to expand...
 
Have you tried to open the database using the shift key,
this should prevent the startup code from running and then
when you time out you can reset the connection.
Try opening Access first, then using the shift key to open
the database with Access.
 
Back
Top