Linked Table Path

[Guy]

How can you locate a remote database being accessed through linked tables? I
have one database with all code and a second with only tables. I would like
to be able to locate the path to the tables specified by the linked table
manager from inside a sub or function.

 

[Stuart McCall]

How can you locate a remote database being accessed through linked tables?
I
have one database with all code and a second with only tables. I would
like
to be able to locate the path to the tables specified by the linked table
manager from inside a sub or function.

Try this:

http://www.smccall.demon.co.uk/DAO.htm#ConnectPart