title: Operation must use an updatable query. (Error 3073)
body: <p>I have written this query:</p>
  
  <pre><code>UPDATE tbl_stock1 SET 
  tbl_stock1.weight1 = (
      select (b.weight1 - c.weight_in_gram) as temp 
      from
          tbl_stock1 as b,
          tbl_sales_item as c 
      where
          b.item_submodel_id = c.item_submodel_id 
          and b.item_submodel_id = tbl_stock1.item_submodel_id 
          and b.status &lt;&gt; 'D' 
          and c.status &lt;&gt; 'D'
      ), 
  tbl_stock1.qty1 = (
      select (b.qty1 - c.qty) as temp1 
      from
          tbl_stock1 as b,
          tbl_sales_item as c 
      where 
          b.item_submodel_id = c.item_submodel_id 
          and b.item_submodel_id = tbl_stock1.item_submodel_id 
          and b.status &lt;&gt; 'D' 
          and c.status &lt;&gt; 'D'
      )
  WHERE
      tbl_stock1.item_submodel_id = 'ISUBM/1' 
      and tbl_stock1.status &lt;&gt; 'D';
  </code></pre>
  
  <p>I got this error message:</p>
  
  <pre><code>Operation must use an updatable query. (Error 3073) Microsoft Access
  </code></pre>
  
  <p>But if I run the same query in SQL Server it will be executed.</p>
  
  <p>Thanks,
  dinesh</p>