Can I see .MDB files that may be linked into another file

[kubanvz]

Hi all,

I have one main Access database file, and many users link into its tables. Can I, through VBA, identify the files that are linked in? Really, I'd like the user name (or computer name) and the file name. Or, can I via VBA break the links, so I can modify the main DB when necessary?

Thanks.

 

[timfoster]

From the source file you can't see which apps are linked easily. You'll need some serious network code that looks for connections to the file from machines on the network. You can however change the names of the tables so that nobody can connect to them.