Compacting a DB

[Guest]

Using MS Access 2007, having build a financial reporting utility, I now have
a potential database corruption problem, given that the reports imported and
then removed and reimported leave the DB growing in size, where if it were to
be compacted without closing we would never reach the max size of a DB being
2GB. How can I autiomate the Compact routine from within the VBA script that
imports and deletes these tables, without existing the DB? Or can this be
done, if not how do I prevent the DB reaching ist's maximum size without the
user having to remember to do this manually?

Thnak you

 

[Guest]

You cannot do a compact and repair operation while executing code in your
application. A compact & repair must be done externally if you want to
automate it.