How to get full path to linked tables

  • Thread starter Thread starter Rick
  • Start date Start date
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
 
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
 
Back
Top