Checking Network Drive status

[Firemansam]

G'day All,

I was wondering whether there is a way to code using VBA to check the connection status of a network drive when opening an access db. Also if the network drive is not connected a way of opening a log in screen to connect to that network drive.

cheers in advance

 

[The_Doc_Man]

Depends on your version of Access, but I found some things that might be useful in Access help.

Contents >> Programming in Visual Basic >> Visual Basic Language Reference >> Objects >> Drive Object, then browse through the properties. If what you want isn't there, I'm not sure where you would ever find it. I looked in my somewhat older copy of the Win32 API reference but didn't see anything that would easily link back to a network drive. Whereas the help files for the File System object suggest that network drives are fair game.

 

[Firemansam]

Thanks Doc Man that has given me the info that I needed