ACCESS 2010 DB size

[jscriptor09]

Hi folks

I have a DB that reads in large Excel spreadsheets and performs many VBA type queries and so on.

Once done, The DB size goes up from 50MB to something like 400MB



If I compact and repair, it goes back to ~50MB

Questions:
- what is the extra space daken but not releases (the diff between 400MB and 50MB).
- Is there a way to dynamincally (via VBA or otherwise) to compact.

The concern is that id the user does not compact on a regular bases, the DB may go over 2GB.

Thanks for any advice from the Forum

Mike

[RuralGuy]

You can set the db to Compact on close.