开发者

MS Access - Connection fails on load, causes app to not respond

开发者 https://www.devze.com 2023-02-10 09:11 出处:网络
I have an issue.I have an Access Project (currently in access 2007), and the project connection properties are set to point to a hosted SQL database on our network.Unfortunately we had to move the dat

I have an issue. I have an Access Project (currently in access 2007), and the project connection properties are set to point to a hosted SQL database on our network. Unfortunately we had to move the databasem and now I have to change the connection properties as well.

However, when I open the adp file, the first thing it does is try to connect to the old database. I never get prompted or anything, the screen just sits there, and the title bar eventually indicates "not responding".

Anyone know how开发者_如何学JAVA I can get to the connection properties, since Access never gives me a chance to do so?


Have you tried keeping the shift key held down while the database is opening to prevent any start-up forms or macros from running? If that does not help, you can change all the connections from VBScript.

0

精彩评论

暂无评论...
验证码 换一张
取 消