Hello all, I’m trying to figure out how MS Access uses locking files to lock records in a shared database. The following description is from Microsoft’s introduction to .ldb files:
“The .ldb file is used to determine which records are locked in a shared database and by whom.” “The .ldb file contents,
For each person who opens a shared database, the Jet database engine writes an entry in the .ldb file of the database. The size of each .ldb entry is 64 bytes. The first 32 bytes contain the computer name (such as JohnDoe). The second 32 bytes contain the security name (such as Admin). The maximum number of concurrent users that the Jet database engine supports is 255. Therefore, the .ldb file size is never larger than 16 kilobytes.”
My question is, how does the Jet engine know which records are locked given that the information stored in the .ldb file consists of computer name and security name?
