title: Access and classic ASP error 80004005 System resource exceeded
body: <p>An old site on shared hosting has developed an error when executing a simple SQL statement</p>
  
  <pre><code>Microsoft JET Database Engine error '80004005'
  
  System resource exceeded.
  
  /411971/users1.asp, line 68 
  </code></pre>
  
  <p>Line 68 is Set objCon = objCommand.Execute</p>
  
  <p>The Access database isn't large (less than 2Mb), this is a single table query and the table only contains around 500 records.  Field count is only about 20 too with no memo fields.  Nothing has changed in the script.  A compact/repair on the database has no effect, as does creating a new database and copying the table in question too it.</p>
  
  <p>Looking round in the web this would appear to be most likely a web server issue rather than the code (and the behaviour would indicate this too) but I'm not finding anything conclusive - and knowing how shared hosting support works I'd like to have a definitive case before I go to them.  Has anyone else seen this error/behaviour before and what was the problem/solution.</p>
  
  <p>OUTCOME: I made sure I'd tried all the obvious approaches then emailed the ISP support who confirmed it was a server issue and restarted services, which fixed the problem</p>