title: How to compact an MS Access database, while the database is open, using vba
body: <p>I am running a few modules of VBA code. In the middle of running the code crashes as Access reaches its max size of 2GB; but, if I compress the database at that point it is only 200MB. </p>
  
  <p>Is it possible to compress the database at regular intervals while the code is running?</p>