What's linked to my database

[xltmike]

I was recently asked to document all our applications and databases. Is there a way to tell what is linked to a database?
I know how to tell what the source of a linked table is. I'm looking for a way to look in reverse.
example. Database1 is a storage database of all our personal data. Database2 through database100 is linked to database1

Can I go into database1 and see what's linked to it?

Thanks.

 

[FoFa]

I don't think so because links are no persistent.
If any application that uses you DB is active, you should be able to tell via the SERVER and what is attached to that file.
Not sure about any other way.

 

[xltmike]

Thank you. I guess it's the old fashioned way.

Open each application and look at the msysobjects tables to check the database field.

 

[Dennisk]

goto tools/options and show hidden and system files. open MSysObjects and the first column will show any tables with ODBC connections and the second column will give details of all linked tables.