G Gary S Jan 21, 2008 #1 I would like to display what database a table is linked to using code. What is the easiest way of doing that?
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 Jan 21, 2008 #3 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)
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 Mar 27, 2008 #4 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
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
