Find out path of Linked db

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

How do I find out the path of the tables which are linked
from the fe of an mdb, to a be of an mdb? Where can I see
the full path?

Thanks in advance.
 
As long as the DB is .mdb you can use the Linked table
Manager. On the menu:

Tools > Add-ins > Linked Table Manager

if your DB was compiled to an .mde, I do not believe this
will work.
 
In code you can get it form an imediate window with this,

? Currentdb.TableDefs("Employees").Connect
 
Andy,

I am using Access 2002, but I think this hold true for all version.
Click the tools menu, then option. Make sure the tab is on "View" and
that System Objects and Hidden objects are checked. Click Okay.

Look for a table named MSysObjects and open it. Look in the Database
column for linked tables (to speed up the process, right click a blank
section of the database column and choose filter excluding section).

Hope this helps,
GH
 
Back
Top