title: Access 2016 - Simple update query gives "Operation must use an updateable query" Error
body: <p>I'm trying to transfer the <code>color</code> field value from the <code>dress</code> table to the <code>purchase</code> table as I'm changing my DB's structure slightly.</p>
  
  <p>Here's the query, it's simple enough but I keep getting the error.</p>
  
  <pre><code>UPDATE purchase
  SET purchase.color = (SELECT dress.color
                        FROM dress INNER JOIN purchase
                        ON dress.ID = purchase.dressID);
  </code></pre>
  
  <p>I've also tried without JOIN and putting the condition in the WHERE clause but I get the same error. </p>
  
  <pre><code>UPDATE purchase
  SET purchase.color = (SELECT dress.color
                        FROM dress, purchase
                        WHERE dress.ID = purchase.dressID);
  </code></pre>
  
  <p>I've also read that this error is sometimes due to the file being "read only" or other issues with permission, I've tried everything but nothing seems to work.</p>
  
  <p><a href="https://i.stack.imgur.com/hYjdY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hYjdY.png" alt="Error I&#39;m getting"></a></p>
  
  <p>Edit: also tried this but I get "missing operator" error</p>
  
  <pre><code>UPDATE purchase
  SET purchase.color = dress.color
  FROM dress INNER JOIN purchase ON dress.ID = purchase.dressID;
  </code></pre>