We help IT Professionals succeed at work.

Microaoft Access on a SBS 2011 Server

LockDown32
LockDown32 asked
on
112 Views
Last Modified: 2017-03-20
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

Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

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
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
LockDown32Owner
Top Expert 2016

Author

Commented:
Thanks Jim