Linked Tables

[PJ Usher]

Hi

Access 2000
Is there a way to find out the location of the source table from a
database's linked tables?

Thanks in advance

PJ

 

[Tim Ferguson]

Is there a way to find out the location of the source table from a
database's linked tables?

Open the VBA editor, find the immediate window and enter the following:

debug.print Tabledefs("MyTable").Connect


HTH


Tim F

 

[PJ Usher]

Hi Tim

I get a compile error: Sub or function not defined

Sorry

PJ

 

[John Vinson]

Hi Tim

I get a compile error: Sub or function not defined

Sorry

PJ

I'm sure Tim meant to say

Debug.print CurrentDb.Tabledefs("MyTable").Connect

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Tim Ferguson]

I'm sure Tim meant to say

Debug.print CurrentDb.Tabledefs("MyTable").Connect

Thanks John...


Tim F