How can you find out who has/have an access database currently open on a network?
Thanks for your solutions
How can you find out who has/have an access database currently open on a network?
Thanks for your solutions
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
I like to use the free Jet Utilities from Microsoft
see:
Microsoft Jet Utilities Available in Download Center
Boyd Trimmell aka HiTechCoach
Microsoft Access MVP -2010-2015
Programming: Nine different ways to do it right, a thousand ways to do it wrong.
Binary--it's as easy as 1-10-11