Display what mdb a table is linked to

[Gary S]

I would like to display what database a table is linked to using code. What
is the easiest way of doing that?

 

[Allen Browne]

See:
http://allenbrowne.com/ser-53code.html#GetDataPath

 

[Marshall Barton]

I would like to display what database a table is linked to using code. What
is the easiest way of doing that?

If the real table is in another Access database, you could
use a text box with an expression like:

=Mid(CurrentDb.TableDefs("table name").Connect, 11)

 

[ITperson]

If the real table is in another Access database, you could
use a text box with an expression like:

=Mid(CurrentDb.TableDefs("table name").Connect, 11)

You may also consider creating a query on the MSysObjects Table (hidden).
In the query view put the Database field and the Name field. specify under
Database (for criteria) <> ""

This will show your tables and the database they are linked to.

HTH

Terry