Trace table links in Access 2000

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.

On Wed, 6 Apr 2005 19:19:03 -0700, Mackia
wrote:

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]

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

(david)

"Mackia" wrote in message
...
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.