Shared mode in an Access database - who’s in?

If you're using Access in shared mode, you might be wondering who's currently using the database.

Well this information is actually stored in the *.ldb file (pre Access 2007) or *.laccdb file (Access 2007).
This file automatically opens when you open your Access database in shared mode (this is the default - you can open a database in Exclusive Mode, through the options of the File/Open window) - it manages users and record locking in shared mode.
And you can actually read this file, you only need a more advanced text editor. However, Microsoft offers a special tool, called Jet utilities, containing a LDB viewer which withdraws more exact information about your connected users; you can download it here : It also seems to working under Access 2007.

For any problems with the lockfile, you might go through this article:

And if you want to list users and access through VBA code, this is possible to; for a nice module on this topic go here:

Posted on 14 Sep 2009 · (1) Comments ·
Next entry: Centering horizontal menu in CSS Previous entry: Default database & templates in Access 2007

LogUsersOff.mdb at

Danny  on  19/11/2010  at  14:01
Page 1 of 1 pages