Here’s an additional paper related to our ongoing coverage of queries. This time we’re covering DELETE query syntax in Microsoft Access. In addition to the basics of deleting data and the SQL for DELETE queries, we also cover an interesting situation when DELETE queries fail during multi-table links on non-keyed fields.
If your query fails to delete any records with this message: “Could not delete from the specified tables”, learn why and how to fix it with the DISTINCTROW syntax or setting the Unique Records property to Yes.
For more information on queries in general, read our paper on Microsoft Access Query Tips and Techniques.