I get the error message "Could not delete from the specified tables"

When you run a delete query (delete query: A query (SQL statement) that removes rows matching the criteria that you specify from one or more tables.), Microsoft Office Access 2007 may display the error message Could not delete from the specified tables. This article lists cases in which you can use a delete query, explains why the error message appears, and provides steps for correcting the error.

There are a number of ways to delete records in Access. For a more thorough explanation of deleting records, see the article Delete one or more records from a database.

In this article


Introduction

When you want to delete multiple records from a table in one operation, you can use a delete query. A delete query is successful when it:

Important    You must run the query twice to delete records from both tables.

Top of Page Top of Page

Why am I seeing this error message, and how do I fix it?

If you build a delete query by using multiple tables and the query's Unique Records property is set to No, Access displays the error message Could not delete from the specified tables when you run the query.

To fix this problem, set the query's Unique Records property to Yes.

  1. Open the delete query in Design view.
  2. If the query property sheet is not open, press F4 to open it.
  3. Click the query designer to show the query properties (rather than the field properties).
  4. In the query property sheet, locate the Unique Records property, and set it to Yes.

Top of Page Top of Page

 
 
Applies to:
Access 2007