Found via Google:
http://www.xtremevbtalk.com/showthread.php?t=146146

--
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

The code at http://www.mvps.org/access/api/api0003.htm will let you convert
CurrentDB.Name to a UNC string.

Using that code, here's a function which I use to convert a mapped drice
path to a UNC path.

'---------------------------------------------------------------------------------------
' Procedure : UNCFolder
' Last Edit : 03 Apr 2006
' Author    : Rob Parker
' Purpose   : Convert a network path to a UNC path
'---------------------------------------------------------------------------------------
'
Public Function UNCFolder(strFolder As String) As String
 Dim strDrive As String

 strDrive = Left(strFolder, 3)
 If fDriveType(strDrive) = "Network drive" Then
   UNCFolder = fGetUNCPath(Left$(strDrive, Len(strDrive) - 1))
   'fGetUNCPath returns a null-terminated string - need to parse to null
before concatenating rest of folder string
   UNCFolder = Mid$(UNCFolder, 1, InStr(UNCFolder, vbNullChar) - 1)
   UNCFolder = UNCFolder & Mid$(strFolder, 3)
 Else
   UNCFolder = strFolder
 End If
End Function

HTH,

Rob

wow.. good stuff.

Of course-- you don't really need to use that linked tables BS--
Linked tables are a complete waste of time.

you really shoud be using SQL Server-- then you wouldn't worry about
linked tables.

-Aaron