How to Fix Microsoft Access Crashing When Copying a Record
Question details
The user experiences an application crash in Microsoft Access when attempting to duplicate database entries using the Copy Record command after a recent software update.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Duplicating existing records to quickly create new units with similar specifications within a database.
- Observed behavior
- Microsoft Access freezes and crashes unexpectedly the moment the Copy Record action is triggered.
Before proceeding with troubleshooting, ensure you have made a complete backup copy of your Access database file (.accdb or .mdb) to prevent any accidental data loss.
Isolate the Issue with Notepad and Access Templates
Use this diagnostic process to determine if the crash is caused by a system-wide clipboard issue, a corrupted database file, or an application-level bug.
Software updates can sometimes interfere with Windows clipboard operations or specific database files. By testing basic copy-paste functions in other environments, you can narrow down the exact source of the crash.
Open Notepad on your computer, type a few words, and try highlighting, copying, and pasting the text. If this crashes or fails, the issue is related to your Windows operating system's clipboard service, not Access.
Open Microsoft Access without loading your current database. Navigate to File > New and select a standard built-in template to create a fresh database. Attempt to copy a record in this new file to see if the crash still occurs.
Navigate to File > Account in Microsoft Access and note the exact build and version number under 'About Access'. This information is crucial for identifying if you are on a specific update release known to have copy-record bugs.

Compact and Repair the Database
Use this built-in Access tool to fix internal database corruption and eliminate bloated temporary data that might be causing the copy command to fail.
Repair the Microsoft Office Installation
If Access crashes universally across all templates and databases, run an Office repair to fix damaged application files caused by the recent update.
Experience Crash-Free Productivity with WPS Office
While Microsoft Access is built for complex relational databases, for everyday data tracking, calculations, and document creation without the frustration of constant crashes, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for all your core spreadsheet, document, and presentation needs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the setup file and follow the quick installation prompts to set up the software.
- 3. Manage Data Smoothly: Open WPS Spreadsheets to reliably manage, organize, and duplicate your data without worrying about application crashes.

Frequently Asked Questions
Why does Microsoft Access crash after a recent Office update?
Office updates can occasionally introduce unforeseen bugs or compatibility issues with your existing database macros, VBA code, or the Windows clipboard service. This can lead to unexpected crashes during routine memory-intensive actions like copying and pasting records.
How can I duplicate records in Access without using the Copy Record command?
If the default Copy Record command is crashing, you can safely duplicate data by running an Append Query designed to insert a new row based on selected criteria. Alternatively, you can use a short VBA script triggered by a form button to clone the current record's values into a new entry.
Where can I find the exact crash error logs for Microsoft Access?
To identify why Access is crashing, open the Windows 'Event Viewer' tool, navigate to 'Windows Logs' > 'Application', and look for 'Error' level events related to 'MSACCESS.EXE'. The faulting module name listed in these logs can help pinpoint the exact cause.




