title: Operation must use an updatable query. (Error 3073) Microsoft Access
body: <p>On some Microsoft Access queries, I get the following message:  Operation must use an updatable query. (Error 3073).  I work around it by using temporary tables, but I'm wondering if there's a better way.  All the tables involved have a primary key. Here's the code:</p>
  
  <pre><code>UPDATE CLOG SET CLOG.NEXTDUE = (
      SELECT H1.paidthru 
      FROM CTRHIST as H1
      WHERE H1.ACCT = clog.ACCT AND
      H1.SEQNO = (
          SELECT MAX(SEQNO) 
          FROM CTRHIST 
          WHERE CTRHIST.ACCT = Clog.ACCT AND 
          CTRHIST.AMTPAID &gt; 0 AND
          CTRHIST.DATEPAID &lt; CLOG.UPDATED_ON
      )
  )
  WHERE CLOG.NEXTDUE IS NULL;
  </code></pre>