Trace table links in Access 2000

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

Guest

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.
 
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.
Click to expand...

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)
 
Back
Top