title: MS Access error "Operation must use an updatable query" on Update
body: <p>I'm migratting a MS Access system into a mySQL system with PHP PDO. Everything's ok until PHP stop readding some records on an Access table. This table has an ID field that's a Long Integer datatype. I don't know why but the ID starts from 0 to 16949 then jumps to 36573745 and ends at 36581986. These higher numbers the PDO doesn't read, I can't figure out why.</p>
  
  <p>Anyway to workaround this, I'm trying to UPDATE these higher numbers to continue the normal sequence of the lower ID's. But Access can't understand my query and I don't know how to make it run.</p>
  
  <p>This is the query </p>
  
  <pre><code>UPDATE Validador_Manut SET ID = (
      SELECT (Max(ID) + 1) FROM Validador_Manut WHERE ID &lt; 100000
  ) WHERE ID &gt; 100000
  </code></pre>
  
  <p>It's shows me this error <code>Uperation must use an updatable query</code>.</p>