Linked table manager

[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

 

[Rick Brandt]

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

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]

I am sure you meant Connect rather Database in the SQL String???

 

[Rick Brandt]

I am sure you meant Connect rather Database in the SQL String???

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

 

[Van T. Dinh]

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.