Address of linked tables

[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

 

[Allen Browne]

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

 

[Leslie Isaacs]

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

 

[Allen Browne]

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.

 

[Leslie Isaacs]

Many thanks Allen - that worked great!
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.