Others

Fix a Microsoft Access Delete Query for Records in Another Table

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 869 views

Question details

Delete records from an Access table when matching records exist in another table.

Fix a Microsoft Access Delete Query for Records in Another Table
Product
Microsoft Access
Device & OS
not provided
Scenario
A delete query joins a target table to an exclusion list to identify matching records.
Observed behavior
The query identifies matching records but reports that the delete table is not specified or that records cannot be deleted.
Before you start

Identify the table whose records should be deleted and confirm that the join fields match the intended exclusion-list records. Run the query as a Select query first to review the affected records.

Solution 1Recommended

Remove Exclusion-List Fields and Select the Delete Table

Use this approach when the query finds the right matches but includes fields from the exclusion list in the delete grid.

1
Open the query in Design View

In the Access Navigation Pane, right-click the query and select Design View.

2
Remove the exclusion-list fields

In the query design grid, remove tbl_MT_32117_SC_Exclude_List.SC_Nbr and tbl_MT_32117_SC_Exclude_List.[Location Nbr]. Leave the joins between the tables in place.

3
Set the delete target

On the Query Design tab, select Delete. Add the intended target table's asterisk (*) to the grid and verify that its Delete row says From.

4
Review and run the query

Switch to Select on the Query Design tab and use Datasheet View to review the matching target records. Return to Design View, select Delete again, confirm the target table, and click Run.

Remove Exclusion-List Fields and Select the Delete Table
Check the target table: The exclusion list is used to find matches; its records should not be selected as the delete target unless you intend to delete them.
Free Microsoft Office alternative

Work With Exported Access Data in WPS Office

WPS Office is a free, lightweight alternative for everyday document and spreadsheet work, with a familiar interface and Microsoft Office format compatibility for easy migration. Export Access data to a spreadsheet to review it in WPS; WPS does not run or repair Access delete queries.

Review and filter exported Access records in WPS Spreadsheet.Open and edit Microsoft Excel XLSX and XLS files.Use a familiar interface for everyday spreadsheet work.Work with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access say the delete table is not specified?

The query may not have a clear delete target. Open it in Design View, select Delete on the Query Design tab, and add the intended target table's asterisk (*) with From in the Delete row.

Should I remove the joins when I remove the exclusion-list fields?

No. Remove the exclusion-list fields from the design grid, but keep the joins that identify matching records between the tables.

How can I check which records will be deleted?

In Design View, select Select on the Query Design tab, then open Datasheet View to inspect the matching records before changing the query back to Delete and running it.

Can WPS Office run this Access delete query?

No. Run and troubleshoot the delete query in Microsoft Access. You can export data to an Excel file and open it in WPS Spreadsheet for review.