Issue with backend on network drive

[Ace71425]

Hello. I have an annoying issue at work where half the time when a user restarts the network drives have a red x on them and you have to click on them to "initialize" them. So the database won't open until that is done. Any ideas on some code or method that can automatically simulate the clicking on the drive so that it loads up?

 

[Micron]

I think not. That's an operating system/network issue that should be solved outside of any program you're using. Re-establishing lost connections are really not the purvey of Office software. At best, I think you could test for and trap lost connections upon startup of your db.

 

[apr pillai]

If Network is down then nothing can be done, except restarting the network. If your Server Location is mapped as a Drive on your computer and need refreshing every time then there is a way to stay connected to the Server. You can address the Back-end database for linking Tables, using the direct link method: \\ServerName\FolderName\Sub-Folder Name\Database.mdb. Even if the mapped drive got disconnected or drive-letter changed, this will not affect the back-end front-end table links.