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.