“Could not delete from the specified tables” error
To fix this problem, set the query’s Unique Records property to Yes.
- Open the delete query in Design view.
- If the query property sheet is not open, press F4 to open it.
- Click the query designer to show the query properties (rather than the field properties).
- In the query property sheet, locate the Unique Records property, and set it to Yes.