How to Delete a Duplicate Service Entry in Microsoft Access
Question details
The user needs to safely delete an accidentally created duplicate service entry in an asset-management database without causing referential integrity issues.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Managing an asset-management database where a duplicate service entry was mistakenly created via the front end.
- Observed behavior
- Two identical service entries exist in the asset's history, requiring the careful removal of the duplicate service record and any associated detail records.
Always create a complete backup of your Access database (both front-end and back-end files) before deleting any records to prevent accidental data loss.
Manually Delete the Record and Related Details via Back-End Tables
Use this method if your database front-end lacks a delete button. You must carefully delete child records before the parent record to maintain referential integrity.
A properly structured Access database uses primary and foreign keys to link tables. You must first remove associated details in the ServiceDetails table before deleting the main service record to avoid referential integrity conflicts.
Open the main 'Services' table in Datasheet view. Locate the duplicate service entry and note its unique Primary Key (ID).
Open the 'ServiceDetails' table. Filter the Foreign Key column to match the Primary Key of the duplicate service you want to delete.
Highlight all filtered records in the 'ServiceDetails' table, right-click the row selector, and select 'Delete Record' to remove them.
Return to the 'Services' table, right-click the row selector for the duplicate entry you identified in the first step, and select 'Delete Record'.

Delete the Duplicate Entry Using the Front-End Interface
The safest and most user-friendly way to remove duplicates is through the database's designated front-end forms, if the developer has provided a delete function.
Need a Lightweight Alternative for Your Office Documents?
While Microsoft Access handles complex database management, WPS Office is an excellent, free alternative for your daily document, spreadsheet, and presentation needs. It offers high compatibility with Microsoft Office formats in a lightweight and familiar interface.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the Suite: Run the downloaded installer and follow the quick on-screen instructions to complete the setup.
- 3. Open Office Files: Launch WPS Office and easily open, edit, and save your existing Microsoft Office documents without formatting loss.

Frequently Asked Questions
What is a cascading delete in Microsoft Access?
A cascading delete is a relationship setting in Microsoft Access. When enabled, deleting a record in the primary (parent) table automatically deletes all related records in the associated (child) table, preventing orphaned data.
Why can't I just delete the service record directly?
If related records exist in the ServiceDetails table, deleting the parent record without deleting the child records first will cause a referential integrity error, unless cascading deletes are enabled.
How do I find the primary key of a duplicate record?
Open the specific table in Datasheet view, locate the duplicate entry visually or using the search bar, and note the unique ID number (usually in the first column) assigned to that specific row.
What is the difference between an Access front end and back end?
The back end contains only the data tables where the actual information is stored. The front end contains the queries, forms, reports, and code used by the user to interact with the back-end data.




