Getting the path of a shared drive

[tbiceps]

Will the GetAbsolutePathName method return directory of a shared folder. Different users in different regions access a database with different directory letter drives. I'm looking for a way to map a user's drive in an automated manner without concern of the drive letter.

 

[JerryKlmns]

Sub MapDrives()
Dim WshNetwork As WshNetwork
Dim CheckDrive As WshCollection
Dim i As Long

Set WshNetwork = CreateObject("WScript.Network")
Set CheckDrive = WshNetwork.EnumNetworkDrives()
For i = 0 To CheckDrive.Count - 1 Step 2
   Debug.Print CheckDrive.Item(i)
   Debug.Print UCase(CheckDrive.Item(i + 1))
Next i
Set CheckDrive = Nothing
Set WshNetwork = Nothing
End Sub

But I don't trust mapped drive letter even if I create the mapping myshelf.

Use \\ServerName\Path

If you already created linked tables, there are many posts on how to relink them using VBA to change the mapped drive to \\ServerName\Path

 

[tbiceps]

How would you use \\ServerName\Path?

 

[tbiceps]

Thanks JerryKlmns,

Using \\ServerName\Path is much simpler than what I had anticipated. Great help!