Finding Source of Currently Linked Tables

[Amilcoy]

I have a front end database that is used by a manager to analyse a number of identical databases. (One at a time) The external databases are 'linked ' using Link Tables

How can I find the name of the current external database to which I am linked?

Any help would be appreciated

 

[mdthornton]

If you want to do it in an DB Admin capacity you can bring up the linked table manager from the tools->add-ins menu.

If you want to do it in VB you can use the connect property, something like this:


Dim sConnect, sPath As String
Dim iPos As Integer

sConnect = CurrentDb.TableDefs("myLink&quot.Connect
iPos = InStr(1, "DATABASE=", sPath, vbTextCompare)
sPath = Mid(sConnect, iPos + 10)
MsgBox sPath Best Regards,
Mike