Access Tricks

“Could not delete from the specified tables” error

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.