Source of linked table

[Mike Labosh]

Is there a "correct" place to find the source of where a linked table is
linked from? It's not on the table properties dialog, and it bugs me that I
have to keep looking in MSysObjects.

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!

 

[Allen Browne]

Parse it from the Connect property of the TableDef:
CurrentDb().TableDefs("MyTable").Connect

 

[Lynn Trapp]

Have you tried using the Linked Table Manager? Tools > Database Utilities >
Linked Table Manager

 

[Roger Carlson]

A third way (manual) is to open the table in design view (yes, I know it
will complain - do it anyway). Go to Properties and check the ConnectString
property.
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Mike Labosh]

Have you tried using the Linked Table Manager? Tools > Database Utilities

Linked Table Manager

OMG! DUH! Thanks.

--
Peace & happy computing,

Mike Labosh, MCSD

Feed the children!
Save the whales!
Free the mallocs!

 

[Joan Wild]

Is there a "correct" place to find the source of where a linked table
is linked from? It's not on the table properties dialog, and it bugs
me that I have to keep looking in MSysObjects.

You can see it by opening the table in design view and looking at the
properties dialog - the description property.

Alternatively, hit Ctrl-G and type
?CurrentDb().TableDefs("SomeTable").Connect