Understanding the .LDB File
Every database opened for shared use has a corresponding .LDB file, a locking file created to store computer and security names and to place byte-range locks on the recordset. The .LDB file always has the same name and location as the databases whose locks it's tracking. Access deletes the .LDB file when the last user exits the database file. Twice, Access does not delete the .LDB file:
When the database is marked as damaged (politically correct term)
When the last user out doesn't have delete rights in the folder with the database and .LDB files
The Jet Engine writes an entry to the .LDB file for every user who opens the database. The entry is 64 bytes; the first 32 bytes contain the user's computer name, and the last ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
