Posted on 2015-02-03
I have an Access 2013 application that is split. In the past I have used a mapped drive letter for my connection to the back-end, but I am switching to using a UNC. In the past, when the application first opened I would check to see if there was a valid connection to (for example) Drive Y.
Now, I need some other kind of code to to see if I am connected to the UNC correctly. Additionally, Sometimes the application is taken off site and so the UNC for off-site will be different than the one that is normally used. It would be helpful if I could determine in code, at start-up what UNC the application is using and verify that the connection is valid and working.
What code might I write to obtain that information?