Fix "Could Not Delete From The Specified Tables" Error

Does your Access frequently showing error message “could not delete from the specified tables” each time when you execute a delete query? 

If yes, then definitely you need to fix it in this article you will read about the complete solution over “Could not delete from the specified tables” errors in MS Access database. 

Intro About “Could Not Delete From The Specified Tables" 

Access Database you have such option to delete records with the help of many options. But when you want to delete multiple records from a table in just one operation then there is a chance that you will definitely get such kind of error message.

Using the delete query, you can definitely delete records when it:

• Uses table that is one the "one" side of a one-to-many relationship, and cascading delete is allowed for that relationship.

• Joints two tables containing one to one relationship.

• Contains both the table on one side of a one-to-many relationship and the table on the "many" side of that relationship.

• Uses a single table that doesn’t have any relationship with any other table.

Also Read: Fixes For MS Access "Reserved Error

Note: Recommendation is to execute the query two times to delete records from both tables.

Reasons For Getting “Could Not Delete From The Specified Tables”

The reason that your access database is displaying this kind of error message is if you build a delete query with the help of multiple tables and the query's Unique Records property is set to NO. This leads to the occurrence of the following error message “Could not delete from the specified tables” when you run the query.

Workaround To Fix “Could Not Delete From The Specified Tables” Error

In order to fix this error message, set the query’s unique records property to Yes:

Step 1: Open the delete query in design view.

Step2: if in case the query property sheet is not open, press F4 to open it.

Step 3: tap to the query designer to display the query properties

Step 4: in this query property sheet you needs to find the Unique Records property, and set it to Yes.

Automatic Fix "Could not delete from the specified tables"

Sometimes this error may leads to corrupt your Access Database file; in that case it’s obvious to look for some instant fixes to resolve such corruption issue occurred in your Access database. For this, you just need to use Access Repair And Recovery Tool which is particularly designed to repair corrupt or damaged MS Access database files. This tool follows the powerful algorithm that scans even severely corrupted access database files. Besides that it’s highly interactive GUI that helps user to easily operate and repair Access database without making changes in the original structure of the file. It easily restores damage or corrupt tables, queries, indexes and other data.

Conclusion:

Try all these aforementioned workaround to resolve this "Could not delete from the specified tables" error. As this will surely work.