We have moved our SQL Server instance to a new hosting company. Months later (after the overlapping migration period), front office have dug up an old adp file (old-school access data project) which connects to our (now non-existing) SQL Server. I need to change the connection string inside.
The file won't open, and crashes Access when I try. I have searched in vain and only come across: "Hold down SHIFT while opening the file". This doesn't solve it.
Has anyone experienced this and has a solution?
Well, I am going to close this question. Issue still exists (as such), but we are simply deleting the adp file now and build a replacement from scratch. I have now tried everything I can come to think of, including renaming the file extension to .mdb or .accdb, and unplugging the pc from any network connection while opening.
Every attempt ends in the same: Access does not respond, and I have to force-kill the application. I don't even know if the issue is what I suspect: the connection string being invalid due to a change of server names. But I can't think of any other explanation.