Finding Db's Linked in

[Moxy1]

Lets say I have DatabaseA with tblOriginal and somebody creates DatabaseB and creates a link to DatabaseA.tblOriginal. From DatabaseA can i identify that DatabaseB and any other database that is linked in to tblOriginal?

 

[oharab]

The only way that I think you could even attempt this is to have DatabaseA open on a machine & some code running that monitors the ldb file. When another machine opens the table, it will usually create an entry in the ldb file, even if it's via a linked table. You would then be able to see at least which machines/users are opening the database, but I'm not aware of any code which will allow you to discover what the actual file you're being linked from will be.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.