Linked Tables

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi everyone,

I have a database with some linked tbales in it, but I
need to find out where the original tables are located
that these are linked to. If i right click the table and
go to properties it doesn't tell me.

Is there a way to find this out without searching through
lots of databases on differant network drives?

Thanks
 
Or:
IN the immediate window (CTRL-G),

?Currentdb.TableDefs("TableName").Connect


Chris Nebinger
 
A third method is to hoover the mouse over the linked Table. After a short
while, the Coonection String will be display as a tip with yellow
background.
 
Back
Top