Code to check for Shortcuts (1 Viewer)

[LadyDi]

I have a database that is split and I want the users to have a copy of the database on their harddrive, instead of using it off the network drive. The problem is that some of my users are over seas and the desktop on their computers is linked to a network. I have code that works great if the harddrive is a C or a D. However, I am having a lot of trouble getting it to work with the network drive because it isn't assigned a letter (it starts out something like this \\ad.company.com\user\Homedirs). Could you tell me how to get my code to allow this as a harddrive? Is there a way to do a nested Case statement? Below is the code that I am currently using. Any assistance you can provide would be greatly appreciated.

Select Case Left(CurrentProject.Path, 1)
            Case "C", "D"
              ' Do nothing
              
            Case Else
               MsgBox "Run this database from a copy on your desktop not a shortcut or off the server", vbCritical, "Error"
                Application.Quit
  End Select

 

[Uncle Gizmo]

I think you need to read up about the UNC naming convention, I Googled for "MS Access" UNC and I found the following results:-
Link to backend tables using UNC instead of mapped drive
How to get a UNC path name?
UNC path to a folder on my local computer
2.2.57 UNC