How to get full path to linked tables

R

Rick

Is there a way to get the full path name to the linked tables from
Access2000? The tables (.mdb) were split from the .mde and reside in the
Users data area.

Thank you for your help.
... rick
 
J

Jamie

Here a function I wrote for this:

Public Function getBackEndPath(strTable as String) As String

On Error GoTo getBackEndPath_Error

getBackEndPath =
VBA.Mid$(Access.CurrentDb().TableDefs(strTable).Connect, 11)

On Error GoTo 0
Exit Function

getBackEndPath_Error:

VBA.MsgBox "Error " & VBA.err.Number & " (" & VBA.err.Description & _
")", VBA.vbCritical

End Function

Jamie
 
Top