Microaoft Access on a SBS 2011 Server

LockDown32
LockDown32 used Ask the Experts™
on
Windows 10 Professional workstations. When you look at Open Files in computer management from the server why would an Access .ldb file  have 17 locks when only one person has it opened?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
JET uses extended byte range locking against the Ldb file to place locks on the database file.

Jim
LockDown32Owner
Top Expert 2016

Author

Commented:
So that is expected behavior? 17 locks even though only one person has it opened?
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Yup.

Could have hundreds or thousands of locks on it.  Default lock setting is 9,500 locks per user.

It's either that or you have "phantom" users; people who disconnect abnormally and left locks hanging.   You can check that easily enough; just have the one user log out.

 Locks should go to zero and the LDB file should disappear if they have delete privs.

Jim.
LockDown32Owner
Top Expert 2016

Author

Commented:
Thanks Jim

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial