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.
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.