Linked table manager

  • Thread starter Thread starter Rover
  • Start date Start date
R

Rover

How do I see where tables are currently linked? If the path is longer
than the Linked Table Manger window you cannot see the full link and the
window cannot be resized. Access 2000. Windows XP Pro.

TIA
Jim
 
Rover said:
How do I see where tables are currently linked? If the path is longer
than the Linked Table Manger window you cannot see the full link and
the window cannot be resized. Access 2000. Windows XP Pro.

TIA
Jim
Click to expand...

Go into design view of the link and look at its Property sheet. The path to the
back ind file will be in the Description.

You can also use the following query...

SELECT MSysObjects.Name, MSysObjects.ForeignName, MSysObjects.Database
FROM MSysObjects
WHERE (((MSysObjects.Database) Is Not Null));
 
Van T. Dinh said:
I am sure you meant Connect rather Database in the SQL String???
Click to expand...

It would be the Connect field for ODBC links, but in my test using linked tables
from an external MDB that field contained nothing and it was the Database field
that gave the path to the other file (I was a bit surprised myself).
 
Thanks, Rick.

I didn't realise that the text in the yellow context pop-up (when hovering
the mouse on the linked Tables) comes from different Fields in MSysObject.
For the last 2 years, I mainly work with SQL Server Back-End so I mainly use
only Connect.
 
Back
Top