Linked tables

  • Thread starter Thread starter jenny
  • Start date Start date
J

jenny

Hi,
Is there a way to check to find out what is the source
for the linked table, once the table linked to different
dabatase/files?
Thanks,
Jenny
 
Hi,
Is there a way to check to find out what is the source
for the linked table, once the table linked to different
dabatase/files?
Thanks,
Jenny
Click to expand...

Look at the Connection property of the Tabledef object.
 
When you hover the mouse on the Table name in the Tables
Container of the Database Containers window, the Tool Tip
will show the Source Database.

This is in AXP, not sure about A2K or A97.

BTW, John meant the Connect Property not Connection if you
want to use code o find out the Source Database.

HTH
Van T. Dinh
MVP (Access)
 
Paste this into the SQL view of a new query:

SELECT Database, Name
FROM MSysObjects
WHERE Database Is Not Null;
 
Back
Top