Trace table links in Access 2000

[Mackia]

I have inherited a database which is split and containes linked tables. I
need to obtain the file path to the linked tables to source the backend data
tables.

 

[John Vinson]

I have inherited a database which is split and containes linked tables. I
need to obtain the file path to the linked tables to source the backend data
tables.

A couple of ways to do this: Tools... Database Utilities... Linked
Table Manager (this might not work because the name may be longer than
the width of the window); another way is to look at the Connect
property of the tabledef object. Type Ctrl-G and in the Immediate
window type

?CurrentDb.Tabledefs("SomeTableName").Connect


John W. Vinson[MVP]

 

[david epsom dot com dot au]

Open a table link in design view. Right click on
the window title (table name), and select 'properties'

(david)