PDA

View Full Version : How to find out who has/have an access database currently open?



wedd
11-11-2010, 12:42 PM
How can you find out who has/have an access database currently open on a network?


Thanks for your solutions :friends:

hansup
11-11-2010, 12:52 PM
Information about connected users is maintained in the "lock file" ... if your database file is named MyDb.mdb, the lock file will be MyDb.ldb

You may find this link useful (LDB Viewer Form): http://www.mvps.org/access/modules/mdl0055.htm

HiTechCoach
11-11-2010, 10:39 PM
I like to use the free Jet Utilities from Microsoft

see:
Microsoft Jet Utilities Available in Download Center (http://support.microsoft.com/kb/176670)