Should You Close Microsoft Access Before Copying an ACCDB Backup?
Question details
The user is asking whether it is safe to copy an Access .accdb database file while it is still open, expressing concern over losing active table view configurations like sorting and filtering if forced to close the application.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Creating a backup copy of a Microsoft Access .accdb database file.
- Observed behavior
- Attempting to copy an open database leaves the .laccdb lock file active, which can result in data corruption or an unreliable backup copy.
Make sure to explicitly save your current table layouts, sorting, and filtering configurations in Access so you do not lose your customized views when closing the database.
Close Microsoft Access to Ensure a Reliable Backup
Properly closing the database application releases the .laccdb lock file, ensuring your copied backup is safe, complete, and free from corruption.
When Microsoft Access opens an .accdb database, it automatically generates a temporary .laccdb lock file in the same directory. This file tracks active users and manages record-locking to prevent conflicting edits.
Copying the .accdb database while this lock file is active means the database is still in use. This can result in incomplete data writes or an unstable backup file that fails to open when restored.
Press Ctrl+S or click the Save icon to preserve any active table views, filtering, or sorting configurations you want to keep for your next session.
Click 'File' and select 'Close', or fully exit Microsoft Access by clicking the 'X' in the top right corner.
Open Windows File Explorer and navigate to the folder containing your database. Confirm that the temporary .laccdb file has disappeared.
Right-click the .accdb file, select 'Copy', navigate to your secure backup folder, right-click an empty space, and select 'Paste'.

Looking for a Lightweight Office Alternative?
While Microsoft Access is designed for complex relational databases, for your everyday spreadsheet, document, and presentation needs, WPS Office offers a free, lightweight, and powerful alternative. Experience a familiar interface and seamless migration without the heavy subscription fees.
- 1. Download the installer: Visit the official WPS Office website and click the free download button.
- 2. Install the software: Run the downloaded executable file and follow the simple on-screen instructions.
- 3. Open existing Office files: Launch WPS Office to easily open, edit, and secure your Excel spreadsheets and Word documents.

Frequently Asked Questions
What is the .laccdb file in Microsoft Access?
The .laccdb file is a locking mechanism created automatically when you open an .accdb database. It tracks who has the database open and prevents multiple users from modifying the same record simultaneously. It is automatically deleted when the last user closes the database.
Can I copy an Access database while it is open?
While the Windows operating system might physically allow you to copy the file, copying an open database (marked by an active .laccdb file) is highly discouraged. It risks creating an incomplete, corrupted, or entirely unusable backup.
How do I save my table sorting and filtering views before closing?
To preserve your current table view, click the 'Save' icon on the Quick Access Toolbar or press Ctrl+S while the specific table is active on your screen. Access will save the layout, column widths, sorting, and filtering criteria for your next session.




