How to get full path to linked tables

[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

 

[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

 

[Rick]

Thank you very much Jamie.