Linked Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherited a HUGE mess of a database. It has links to EXCEL files.
How can i find out the path to these files? I belive they are on a corporate
shared drive, and have done a few searches with Explorer, with no success.

Please help.

Thank you,
Jim McDowell
 
SELECT MSysObjects.Database, MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE MSysObjects.Type=6;

Type 6 is links.
Name is the name of the Link.
Database is the path and name of the linked file.
 
BTW, if you happen to be working with an older version of Access, the
command path is

Tools | Add-Ins | Linked Table Manager

LeAnne
 
Back
Top