Is the path mapped for the user already?

Could run a net use PATH command first

Hi Rob, the Application.FileDialog property should give you a dialog box that lets you select network paths.  Sample code:

Sub PickFolder()
    Dim fd, fnc, fn
    Set fd = Application.FileDialog(4)
    fd.Title = "Pick a folder"
    fd.InitialFileName = ""
    fd.AllowMultiSelect = False
    fd.show
    fnc = fd.SelectedItems.Count
    If fnc > 0 Then MsgBox "Folder selected:" & fd.SelectedItems(1)
End Sub

Microsoft's documentation is here:    https://learn.microsoft.com/en-us/office/vba/api/access.application.filedialog

FileDialog(4) gives you the folder picker, and (3) the file picker.  The line "fd.show" will wait till the user makes a selection before progressing.  A selection count (zero if nothing selected), and the full path of the selected file or folder, if any, will be returned.  If the file/folder resides in a network share, the full path will be in UNC format:  \\mypc\mysharedfolder

Yeah, using Kevin's example, even if I pick my server drive, which is mapped to Z:\Database, it still returns \\SERVER\Database