DAO can cause the .MDB Size to Increase

Provided by the FMS Development Team

If you are using DAO to create Recordset or QueryDef objects, make sure you explicitly close the objects when they are no longer needed by using the Close method. Otherwise, DAO increases its needed resources which in turn causes the bloating of the .mdb size.

To decrease the size of the database, use the Compact utility in Microsoft Access. As always, make sure you make a backup copy first before proceeding.

Additional Resources



Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.

Darren D.

View all FMS products for Microsoft Access All Our Microsoft Access Products



Free Product Catalog from FMS