How to Stop Microsoft Access from Creating Unwanted Backup Files
Question details
The user needs to know why Microsoft Access automatically generates backup files when opening, using, or compacting databases, and how to stop this behavior.
- Product
- Microsoft Access
- Device & OS
- Windows 11 / Windows 10
- Scenario
- Opening, using, or running Compact and Repair on an Access database.
- Observed behavior
- Access unexpectedly creates backup database files. Sometimes they disappear upon closing, but often they are left behind, suggesting the application is stuck in a crash recovery loop.
Ensure you have a secure, manual backup of your original Access database file stored in a separate folder before attempting any recovery or import steps.
Bypass Startup Code to Isolate the Issue
Determine if the automatic backup generation is caused by faulty VBA code executing as soon as the database is opened.
Often, Access creates backup files because it is attempting to recover from a crash that happens silently in the background. This can be triggered by conflicting or corrupt VBA code running during the database startup phase.
Double-click the database file to open it, then close it immediately to see if a backup file is still generated.
Press and hold the Shift key on your keyboard, then double-click the Access database file. Continue holding the Shift key until the database is fully open.
Check your file explorer. If bypassing the startup code prevents the backup file from being created, you will need to inspect your AutoExec macros or startup VBA scripts for errors.
Import Objects into a Blank Database
Resolve deep-seated corruption by migrating your tables, queries, and forms to a completely fresh database file.
Perform an Online Repair of Microsoft Office
Fix corrupted application files that might be causing Access to malfunction on newer operating systems like Windows 11.
Looking for a Lighter, Reliable Office Suite?
While Microsoft Access handles complex database management, your daily document, spreadsheet, and presentation needs can be met effortlessly with WPS Office. It's a free, highly compatible, and lightweight suite that runs smoothly without bogging down your system with endless background processes.
- 1. Download the installer: Visit the official WPS Office website and click the Free Download button.
- 2. Run the setup: Open the downloaded executable file to begin the installation process.
- 3. Start working: Launch WPS Office and enjoy seamless compatibility with standard document formats.
Frequently Asked Questions
Why does Access create a file with a .laccdb or .ldb extension?
These are record-locking files created temporarily when a database is opened by a user. They track who is accessing the database and prevent conflicting edits. They normally disappear automatically when the database is closed.
Can moving a database from Windows 10 to Windows 11 cause backup errors?
Yes, sometimes operating system upgrades or specific Windows 11 environments can introduce compatibility issues or permission conflicts, leading Access into a crash-recovery loop. Bypassing startup code or repairing Office often helps.
What should I do if importing objects to a new database fails?
If the import process fails or the backup issue persists in the new database, there may be deep-seated corruption in specific VBA modules or tables. You will need to inspect and debug the VBA code or restore the database from an older, stable backup.
