Relinking to a New SQL Server 1

[chezealot9]

Hey Guys, Im moving a adp database from one sql server to another, how do I update the access front end to point to the new one?

 

[drctx]

open the .adp and go to file/connection and you can change the connection information.

 

[shankel]

I had a SQL Server IP change, and I didn't change the ADP file. When I open the apd, of course it can't connect.
Is there a way to change the connection?
Or create a new one, and import the old forms and reports?

 

[shankel]

I figured it out. I held the shift key to cancel the form load, and was able to change the connection.

 

[drctx]

you could also update the connection by opening the adp then goto file,connection.