Find all mdb's that are linked to my .mdb table

[aarondewberry]

Hi

I have been frantically searching the net trying to find if there is any way of finding all .mdb's that have linked to a table in my .mdb called tblAgent.

I have to make changes to fields in my table, hence wanting to know if the changes will affect any other queries linking to it, in other .mdb's.

Any help would be good.

 

[jsteph]

Depending on the version of Access, you may be able to look at the .LDB file of the backend and see what users are in the backend. However I don't think it'll tell you the db name.

There's always the old-fashioned way of renaming the backend and wait for the frantic phone calls...
--Jim