title: How to get delete query to work in MS Access
body: <p>I have set up a subquery to select my records and then the delete query to perform the action. When I run it, I get an error message saying: </p>
  
  <blockquote>
    <p>Could not delete from specified tables</p>
  </blockquote>
  
  <p>Here my SQL code in the delete query:</p>
  
  <pre><code>PARAMETERS UnitID Short;
  DELETE DISTINCTROW qry_exp_comments_select.*
  FROM qry_exp_comments_select;
  </code></pre>
  
  <p>And the called subquery:</p>
  
  <pre><code>PARAMETERS UnitID Short;
  SELECT tbl_Comments.*, tbl_Activity.ActivityID
  FROM tbl_BusUnits INNER JOIN (tbl_Activity INNER JOIN tbl_Comments ON tbl_Activity.ActivityID = tbl_Comments.ActivityID) ON tbl_BusUnits.UnitID = tbl_Activity.UnitID
  WHERE (((tbl_BusUnits.UnitID)&lt;&gt;[UnitID]));
  </code></pre>
  
  <p><strong>Why won't the query work?</strong> I have tried to set it up as the one in the following thread: <a href="https://stackoverflow.com/questions/23228073/ms-access-delete-query-syntax-combined-with-inner-join-problems">MS ACCESS delete query syntax combined with inner join problems</a></p>