Display what mdb a table is linked to

G

Gary S

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

Marshall Barton

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


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)
 
I

ITperson

Marshall Barton said:
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)
Click to expand...
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
 
Top