Fix Microsoft Access Record Is Deleted Error When Opening Forms
Question details
The user encounters a 'Record is deleted' error message when attempting to open a form in an older Microsoft Access database.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Opening a form that relies on a linked table, front-end/back-end database connection, or specific VBA procedures.
- Observed behavior
- Access blocks the form from loading properly and displays a 'Record is deleted' error, usually indicating a broken data link rather than an actual deleted record.
Before making any modifications to your database connections or table links, verify that the back-end database file has not been renamed or moved from its original network location.
Refresh Linked Table Connections
Use the Linked Table Manager to update and fix broken connections between the front-end form and the back-end database.
If the form's source table resides in a back-end database that was recently moved, changed, or momentarily disconnected, the front-end database will lose access to the data, resulting in a false 'Record is deleted' error.
Open your Microsoft Access database. Go to the 'External Data' tab on the ribbon and click on 'Linked Table Manager'.
Check the boxes next to the tables that supply data to your problematic form. If you are unsure, you can click 'Select All'.
Check the 'Always prompt for new location' box at the bottom, then click 'OK'. Browse to the new or correct location of your back-end database file and click 'Open' to refresh the links.
Verify the Form's Record Source
Ensure the form is configured to pull data from an existing and valid table or query.
Inspect Form VBA Procedures
Debug the VBA code that triggers when the form opens, such as the 'EE Master Form' procedure.
Looking for a Reliable and Free Office Suite? Try WPS Office
While Microsoft Access handles complex databases, your daily document, spreadsheet, and presentation needs require a fast and reliable suite. WPS Office offers a powerful, lightweight, and completely free alternative to Microsoft Office. It seamlessly opens and edits Word, Excel, and PowerPoint files with a highly familiar user interface.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the software.
- 3. Open Office Documents: Launch WPS Office to instantly open, edit, and save your existing Office documents with total format compatibility.
Frequently Asked Questions
Why does Access say 'Record is deleted' when no record was actually deleted?
This error is frequently a symptom of a broken connection to a linked table in a back-end database, a stale network connection, or database corruption, rather than an actual deleted row of data.
Can network issues cause the 'Record is deleted' error in Access?
Yes. If the back-end database is hosted on a network drive and the connection drops even momentarily, Access may lose its pointer to the active record, triggering this error when the form tries to load it.
How do I know if the error is caused by the front-end form or the back-end database?
Try opening the source table directly from the database Navigation Pane. If the table opens and displays data correctly, the issue is likely within the front-end form's properties or VBA code. If the table fails to open, the back-end link is broken.
