Source of linked table

M

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!
 
A

Allen Browne

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

Lynn Trapp

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

Mike Labosh

Have you tried using the Linked Table Manager? Tools > Database Utilities
Linked Table Manager
Click to expand...

OMG! DUH! Thanks.

--
Peace & happy computing,

Mike Labosh, MCSD

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

Joan Wild

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

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
 
Top