An error message “Could not delete from the specified tables” appears when user execute a delete query, in this article you will read about the complete solution over “Could not delete from the specified tables” errors in MS Access database.
In Ms Access Database you can delete records with the help of many options, but when you want to delete multiple records from a table in one operation then there is a chance that you will receive this kind of error message.
You can successfully delete records using a delete query when it:
- Joints two tables that have a one-to-one relationship.
- Uses a single table that doesn’t have a relationship to any other table.
- Uses a table that is one the “one” side of a one-to-many relationship, and cascading delete is allowed for that relationship.
- Contains both the table on the “one” side of a one-to-many relationship and the table on the “many” side of that relationship.
Note: It is recommended to execute the query two times to delete records from both tables.
Why am I seeing this error message, and how do I fix it?
Your Access database is displaying this kind of error message if you build a delete query with the help of multiple tables and the query’s Unique Records property is set to No. MS Access database shows the error message “Could not delete from the specified tables” when you run the query.
In order to fix this issue, set the query’s Unique Records property to Yes:
Step 1: Open the delete query in Design view.
Step2: If the query property sheet is not open, press F4 to open it.
Step 3: Click on the query designer to display the query properties
Step 4: In the query property sheet you have to find the Unique Records property, and set it to Yes.
Automatic Fix “Could not delete from the specified tables”
Access Database Repair is software that is particularly designed to repair corrupt or damaged MS Access database files. It comes with powerful algorithm that scans even severely corrupted access database files. It also has 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. This tool can easily fix all minor and major database errors and problems of MS Access 2013, 2010, 2007, 2003, 2002, 2000 on almost all version of Windows operating system such as Windows 8/7/Vista/XP/2003. Free trial version is available that you can install to check the features and reliability of the software.
User Guide: fix “Could not delete from the specified tables”
Step 1: Download and install Access Repair tool.
Step 2: Click on “Open MS Access File” button to add Access file. You will find a pop-up window from where you can search or select for a ‘.mdb’/’.accdb’ file from your PC.
Step 3: After selecting the file click on “Scan” button to start the scanning process.
Step 4: After the scanning process you will now be able to Preview the recovered database.
Step 5: Next you will be able to preview of the database query.