Others

Fix Microsoft Access DeleteRecord Not Available Error on Forms

Steve K Sep 27, 2026 869 views

Question details

The user is unable to delete records using a form button in Microsoft Access due to a DeleteRecord error linked to table relationships.

How to Fix Access DeleteRecord Is Not Available on a Form

Product: Microsoft Access
Device & OS: not provided
Scenario: Attempting to use a delete button on a form that is based on a table located on the 'one' side of a one-to-many relationship.
Observed behavior: The DeleteRecord command is unavailable or fails to execute because Access prevents the deletion to stop related records on the 'many' side from becoming orphaned.

Before you start

Before altering relationship rules or deleting records, ensure you create a backup of your Access database, as cascade deletions cannot be undone and will permanently remove associated data.

Solution 1Recommended

Enable Cascade Delete in Relationship Settings

Use this method if you want Access to automatically delete all related child records whenever a primary parent record is deleted.

When referential integrity is enforced in a one-to-many relationship, Access prevents the deletion of a record on the 'one' side if matching records exist on the 'many' side. Enabling Cascade Delete Related Records resolves this by automatically clearing the dependent data.

Open the Relationships Window

Navigate to the 'Database Tools' tab on the Access ribbon and click on 'Relationships' in the Relationships group.

Edit the Relationship

Locate the link line connecting your primary table (e.g., tblLocations) to the related table. Double-click this line to open the Edit Relationships dialog box.

Enable Cascade Delete

In the dialog box, ensure 'Enforce Referential Integrity' is checked, then check the box for 'Cascade Delete Related Records'. Click 'OK' to save.

Test the Form

Close the Relationships window, reopen your form, and try using the Delete button again. The record and its related dependencies should now delete successfully.

Enable Cascade Delete in Relationship Settings

Warning on Data Loss: Use cascade deletion carefully. Deleting a single record on the parent table will instantly wipe out all associated records in the child tables without prompting for each one.

Solution 2

Manually Delete Related Child Records First

Use this method if you prefer to keep cascade delete disabled to prevent accidental mass data loss.

Free Microsoft Office alternative

Experience a Seamless and Lightweight Office Suite with WPS Office

While Microsoft Access handles complex relational databases, you might find standard Office tools bloated for everyday tasks. WPS Office offers a free, lightweight, and incredibly intuitive alternative for your document, spreadsheet, and presentation needs with zero learning curve.

1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the Software: Run the downloaded installer and follow the quick on-screen instructions to set up the suite in seconds.
3. Open and Edit Your Files: Launch WPS Office and directly open your existing Microsoft Office files with perfect formatting retention.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight installation that runs smoothly on all devices without laggingAll-in-one tabbed interface to manage documents, spreadsheets, and PDFs in one windowFree built-in PDF editor and comprehensive template library

Frequently Asked Questions

Why does referential integrity block the DeleteRecord command?

Referential integrity is a database concept that ensures relationships between tables remain consistent. If it is enforced, Access prevents you from deleting a parent record to ensure child records are not left 'orphaned' without a valid primary key reference.

Is it safe to always leave Cascade Delete enabled?

Not necessarily. While convenient, enabling Cascade Delete can lead to accidental mass data loss. If a user inadvertently deletes a main category record, all sub-records tied to it will vanish automatically. It should only be enabled when it strictly fits your business logic and data model.

Can I recover records deleted by a Cascade Delete operation?

No. Once records are deleted via a cascade delete operation in Microsoft Access, they cannot be undone using the standard 'Undo' command. The only way to recover the lost data is by restoring the database from a previous backup.

Office Quick Solutions