tracking down linked tables

[brucle]

I am trying to deconstruct a database that has several linked tables. Is there a way to find the source database for the linked table from within the original database?

 

[Bat17]

Tools>Database Utilities>Linked table Manager.
this list all of the linked tables so you should be able to see the paths there, unless the paths too long

Peter

 

[MStCyr]

You can also view the system objects, i.e. Tools->Options->View, and then click System Objects. Then open the table MSysObjects. The Database column will show you where the tables are linked from.

 

[brucle]

thankyouthankyouthankyou!

this did the trick! It will be a real lifesaver!. I can't thank you enough!