title: Access DB update one table with value from another
body: <p>I'm trying to update all records in one table with the values found in another table.</p>
  
  <p>I've tried many versions of the same basic query and always get the same error message:</p>
  
  <blockquote>
    <p>Operation must use an updateable
    query.</p>
  </blockquote>
  
  <p>Any thoughts on why this query won't work in Access DB?</p>
  
  <pre><code>UPDATE inventoryDetails as idet
  SET idet.itemDesc = 
  (
      SELECT bomItemDesc
      FROM BOM_TEMPLATES as bt
      WHERE bt.bomModelNumber = idet.modelNumber
  )
  </code></pre>
  
  <p>also tried this because I realized that since the second table has multiple model number records for each modelnumber - and I only need the first description from the first record found for each model number.</p>
  
  <pre><code>UPDATE inventoryDetails as idet
  SET idet.item_desc = 
  (
      SELECT TOP 1 bomItemDescription 
      FROM BOM_TEMPLATES as bt
      WHERE bt.bomModelNumber = idet.modelNumber
  )
  </code></pre>
  
  <p>...still getting the same error though.</p>