Others

How to Delete a Duplicate Service Entry in Microsoft Access

Natalie TaylorNatalie Taylor Oct 22, 2026 868 views

Question details

The user needs to safely delete an accidentally created duplicate service entry in an asset-management database without causing referential integrity issues.

How to Delete a Duplicate Service Entry in Microsoft Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Identify the Primary Key

Open the main 'Services' table in Datasheet view. Locate the duplicate service entry and note its unique Primary Key (ID).

2
Filter the ServiceDetails Table

Open the 'ServiceDetails' table. Filter the Foreign Key column to match the Primary Key of the duplicate service you want to delete.

3
Delete Detail Records

Highlight all filtered records in the 'ServiceDetails' table, right-click the row selector, and select 'Delete Record' to remove them.

4
Delete the Main Service Record

Return to the 'Services' table, right-click the row selector for the duplicate entry you identified in the first step, and select 'Delete Record'.

Manually Delete the Record and Related Details via Back-End Tables
Cascading Deletes: If your database relationships are configured with 'Cascade Delete Related Records' enabled, deleting the main service record will automatically delete the related ServiceDetails records, saving you from performing the manual child-record deletion steps.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the Suite: Run the downloaded installer and follow the quick on-screen instructions to complete the setup.
  3. 3. Open Office Files: Launch WPS Office and easily open, edit, and save your existing Microsoft Office documents without formatting loss.
Completely free and lightweight Office suiteSeamless compatibility with Microsoft Word, Excel, and PowerPoint formatsFamiliar, tabbed user interface for easy migrationBuilt-in PDF editing and conversion tools
microsoft office alternative - wps office

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.