title: Growing MS Access File Size problem
body: <p>I have a large MS Access application with a lot of computations in VBA code.  When I run it it eventually crashes due to excessive file size.  There are a lot of intermediate tables and queries created and subsequently deleted, but Access does not reclaim the space.  I have diligently closed all intermediate record sets and set all temporary objects to nothing, but nothing helps.  The only way I can get my code to run is to run part of it, stop and repair/compress the file then restart the code.  </p>
  
  <p>Isn't there a better way?</p>
  
  <p>Thanks</p>