Linked Tables

[James McDowell]

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

 

[Jerry Whittle]

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.

 

[TedMi]

An easier method:
Tools > Database utilities > Linked Table Manager

 

[LeAnne]

BTW, if you happen to be working with an older version of Access, the
command path is

Tools | Add-Ins | Linked Table Manager

LeAnne