title: "System resource exceeded" when updating recordset, and possibly at other points
body: <p>I'm experiencing an intermittent issue with an application that's Excel 2010 front-end, Access 2010 back end.  It's in use by 5-10 users simultaneously.  Recently, users have started intermittently receiving the following error:</p>
  
  <p><code>Run-time error '3035': System resource exceeded.</code></p>
  
  <p>Sometimes the Debug button is grayed out so I can't jump to the code that caused the error, but when it's available to click, it takes me to the following code:</p>
  
  <pre><code> 'Open connection to back end DB
   Set db = OpenDatabase(dbPath)
  
   'Open a recordset of a table
   Set RS = db.OpenRecordset(Tbl)
  
   'loop through rows in a 2D array
   For i = FR To LR
    RS.AddNew
     'loop through columns of the 2D array
     For j = 1 to LC
      'set values for various fields in the new record, using values from the array
     Next
    RS.Update
   Next
  </code></pre>
  
  <p>Here, the <code>RS.Update</code> is marked as the line that's causing the error.</p>
  
  <p>What's odd is that this problem comes and goes; users will repeatedly receive it when attempting to submit a certain data set, then, several hours later, when they try to submit the same data set again, the operation succeeds without the error.  It's also perplexing that sometimes the Debug button is available and sometimes it isn't.</p>
  
  <p>One issue might be the size of the Access back end; it's currently ~650 MB, and we didn't start getting these messages until it grew to around 600 MB.</p>
  
  <p>Any ideas as to what could be causing this?  Various Google hits indicate that this problem sometimes happens when a join query has too many fields, but this is just a recordset of a table, not a join query.</p>