Can't view the full path of linked table

[Tim Cali]

Is there a way to view the full path of the Linked Table in the Linked Table
manager?

If not, is there some procedure I can use to debug.print them?

Thanks.

 

[Tim Cali]

Thanks Sandra.

Sure, here's some code you can use:

Sub ShowLinkPath()
Dim db As DAO.Database
Dim tdf As DAO.TableDef

Set db = CurrentDb
For Each tdf In db.TableDefs
Debug.Print tdf.Connect
Next tdf
Set tdf = Nothing
Set db = Nothing
End Sub


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Is there a way to view the full path of the Linked Table in the Linked
Table manager?

If not, is there some procedure I can use to debug.print them?

Thanks.