How to compact an MS Access database, while the database is open, using vba
Posted
by tksy
on Stack Overflow
See other posts from Stack Overflow
or by tksy
Published on 2010-05-14T03:59:31Z
Indexed on
2010/05/14
4:14 UTC
Read the original article
Hit count: 273
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.
Is it possible to compress the database at regular intervals while the code is running?
© Stack Overflow or respective owner