Local or Network Drive? 1

[lameid]

Does anybody know of a way to determine if a drive is a mapped network drive or a local drive?

 

[dhookom]

You might want to try API: Enumerating Local and Network Drives from the Access Web.


Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Have a look here:

http://msdn.microsoft.com/en-us/library/t9zt39at(VS.85).aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lameid]

Thanks, both of you.

I went for the scripting method PHV referenced... I feel like my code will eventually not work when I explicitly use dll's.

Anyway a begining translation of the code to VBA...

Sub ListNetworkDirves()
    Dim WSH As Object
    Dim oDrives As Object
    Dim i As Integer
    Set WSH = CreateObject("WScript.Network")
    Set oDrives = WSH.EnumNetworkdrives
    For i = 0 To oDrives.Count - 1 Step 2
        Debug.Print oDrives.Item(i) & " = " & oDrives.Item(i + 1)
    Next i
End Sub

From there any VBA programmer should be able to retask it.
Seems like a good way to start for remaping all connections to UNC paths... Not something I was looking to do, but nice none the less.

 

[lameid]

Right hand is faster than the left... I hate those transpostions---> ListNetworkDirves vs ListNetworkDrives