Address of linked tables

  • Thread starter Thread starter Ruth Isaacs
  • Start date Start date
R

Ruth Isaacs

Hello All

How can I find out the pathname and filename of the mdb that has the linked
tables in my frontend mdb? I have 'inherited' a situation (honestly!) where
I have an access97 frontend with lots of linked tables - which I suspect are
not all in the same backend. I'm sure there must be a way of getting at the
pathname and filename for a particular table (right-click and properties
would have been too obvious!) but cannot see how.

NB Linked Table Manager is not installed and I do not have an A97 CD.

Hope someone can help.

Many thanks
Leslie Isaacs
 
The path is in the Connect property of the TableDef, e.g.:
CurrentDb.TableDefs("MyLinkedTable").Connect

If you can open the table in design view, Access shows this in the
Description of the table (in the Properties box.)
 
Hello Allen

Thanks for your reply.

Please excuse my ignorance, but how do I use the
"CurrentDb.TableDefs("MyLinkedTable").Connect" expression that you have
given me? Do I set this as a column in a query based on the table, or as the
OnClick event of a button on a form, or is it something completely
different. I realise that my question indicates a greater ignorance that you
may have expected, but we've all got to start somewhere!

Thanks again.
Les
 
To find out where Table1 is getting its data from, press Ctrl+G to open the
Immediate Window, and enter:
? CurrentDb.TableDefs("Table1").Connect

If it returns a zero-length string, it is a local table (not a linked
table.) If it is a linked table, the string tells you where the source
database is.
 
Many thanks Allen - that worked great!
Les


Allen Browne said:
To find out where Table1 is getting its data from, press Ctrl+G to open
the Immediate Window, and enter:
? CurrentDb.TableDefs("Table1").Connect

If it returns a zero-length string, it is a local table (not a linked
table.) If it is a linked table, the string tells you where the source
database is.
Click to expand...
 
Back
Top