title: Access 2010 Error 3035 System Resources Exceeded on Update Query
body: <p>I've got a routine that imports and performs some transformations on a 481 MB text file.</p>
  
  <p>The routine crashes on this code block for one workstation (but works fine on our other workstations):</p>
  
  <pre><code>' All of the eleven-digit telephone numbers encountered end in 0. If we get rid of the ending 0,  
  ' we may end up with a valid telephone number.  
  SQLString = "UPDATE " &amp; sTableName &amp; _  
              " SET [ServAddrPhone] = Int([ServAddrPhone]/10) WHERE [ServAddrPhone] &gt;9999999999 ; "
  RoboCallDB.Execute SQLString, dbFailOnError
  </code></pre>
  
  <p>[ServAddrPhone] is a double. The code block scans through some 800,000 records looking for telephone numbers greater than 10-digits, and generally finds about 3,000 records eligible for an update.  </p>
  
  <p>How can this code be optimized to avoid Error 3035? Thanks!</p>