Where do these tables link??

[C Tate]

I have been looking at a database at work. Some of the tables are linked
since there is a small arrow next to them. However, I cannot find out what
they are linked to! How can I do this?

 

[Dirk Goldgar]

I have been looking at a database at work. Some of the tables are
linked since there is a small arrow next to them. However, I cannot
find out what they are linked to! How can I do this?

If you have Access 2002 (and maybe if you have 2000, I'm not sure) the
Connect information is shown in a tooltip if you hover your mouse over
the linked table. If you have Access 97 this doesn't happen. In that
case, press Ctrl+G to open the Immediate Window and enter a command like
this in it (subsituting the name of a linked table you want to trace):

?CurrentDb.TableDefs("LinkedTableName").Connect

 

[C Tate]

Many thanks. I'll try that out soon!

If you have Access 2002 (and maybe if you have 2000, I'm not sure) the
Connect information is shown in a tooltip if you hover your mouse over
the linked table. If you have Access 97 this doesn't happen. In that
case, press Ctrl+G to open the Immediate Window and enter a command like
this in it (subsituting the name of a linked table you want to trace):

?CurrentDb.TableDefs("LinkedTableName").Connect

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)