What Is .laccdb

Content on WhatAnswers is provided "as is" for informational purposes. While we strive for accuracy, we make no guarantees. Content is AI-assisted and should not be used as professional advice.

Last updated: April 10, 2026

Quick Answer: A .laccdb file is a temporary lock file automatically created by Microsoft Access when a database (.mdb or .accdb) is opened, serving to prevent multiple users from making conflicting simultaneous edits. Introduced in Microsoft Access 1.0 (1992), these hidden files coordinate record-level locking in shared databases and are automatically deleted when the database closes.

Key Facts

.laccdb stands for 'Lock Database' and was first introduced with Microsoft Access 1.0 in 1992 as part of the application's multi-user database protection system
The lock file is created in the same directory as the database file and typically ranges from 1 KB to 2 MB in size, containing metadata about locked records and connected users
Files are hidden by default in Windows, making them invisible to most users unless they enable viewing of system files
The .laccdb file is automatically deleted when all users close the database; if a connection drops unexpectedly, the file may persist for several hours
Manually deleting a .laccdb file while the database is open can cause data corruption and loss of unsaved changes, with Windows preventing this action through file locking

Overview

A .laccdb file is a temporary lock file automatically generated by Microsoft Access whenever a database file (.mdb or .accdb format) is opened. The file name mirrors the database file—for example, if you open "Sales.accdb," Access creates "Sales.laccdb" in the same directory. This hidden file serves a critical function in multi-user environments by coordinating access and preventing simultaneous edits that could corrupt data.

The .laccdb extension stands for "Lock Database," though the acronym is rarely explained in user documentation. Created as part of Access's locking mechanism, these files have been a fundamental feature since Microsoft Access 1.0 was released in 1992. The file is typically invisible to users because Windows hides it by default, leading many people to be unaware of its existence or to misinterpret it as a corrupt or unnecessary file.

How It Works

The .laccdb file functions as a coordination mechanism in Access databases, particularly when multiple users access the same file over a network. Here's how it operates:

File Creation: When a user opens an Access database, the application immediately creates a .laccdb file in the same folder. This file contains metadata about which user has the database open and which records or tables are currently locked.
Record Locking: If user restrictions are enabled, Access uses the .laccdb file to track record-level locks. When one user edits a record, that information is written to the lock file, preventing other users from simultaneously editing the same record.
Automatic Deletion: The .laccdb file is automatically deleted when the database is completely closed and no users remain connected. If the connection drops unexpectedly, the file may persist for several hours until Access detects the orphaned connection.
Size and Performance: A typical .laccdb file ranges from 1 KB to 2 MB depending on the number of locked records. In larger databases with many simultaneous users, the file can grow, potentially affecting performance in shared network environments.
Corruption Prevention: The lock file prevents the "database is locked" error that occurred in older systems. By maintaining current lock information, Access ensures that data integrity is preserved even when users work simultaneously.

Key Comparisons

Understanding .laccdb files becomes clearer when compared to similar locking mechanisms in other database systems:

Feature	Microsoft Access (.laccdb)	SQL Server Locks	MySQL Table Locks
Lock File Type	Temporary, local file-based	In-memory, server-based	In-memory, server-based
Granularity	Record-level and file-level	Row, page, and table-level	Table-level (by default)
Visibility	Hidden system file	Not visible to users	Not visible to users
Auto-Cleanup	When database closes	Automatic on connection end	Automatic on query completion
Scalability	Best for small teams (5-10 users)	Scales to thousands of users	Scales to hundreds of users

Why It Matters

The .laccdb file is important for maintaining database integrity and preventing data loss in shared Access environments. Understanding its role helps users and administrators troubleshoot connection issues and avoid data corruption.

Data Safety: Without the .laccdb file's locking mechanism, multiple users could overwrite each other's changes, resulting in permanent data loss. The file ensures that edits are properly serialized across concurrent users.
Network Performance: In slow network environments, the .laccdb file can become a bottleneck. Access must constantly read and update lock information, which can significantly slow performance when many users access the database simultaneously.
Troubleshooting Errors: If users encounter "database is locked" errors or cannot connect to a database, the .laccdb file is often involved. Understanding this file helps IT professionals diagnose connectivity issues and restore access.
File Corruption Risk: Deleting a .laccdb file manually while the database is open can cause serious corruption. Windows prevents this through file locking, but network-based solutions may be more vulnerable to improper deletion.

For modern applications, cloud-based alternatives like Microsoft 365 or SQL Server provide superior locking and scalability compared to file-based Access databases. However, the .laccdb mechanism remains essential for legacy systems and small office environments still relying on traditional Access databases.