|
Free Resources from FMS |
|
|
|
|
"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. |
|
|
|
|
Microsoft
Access Resource Center
DAO can cause the .MDB Size to Increase
Provided by: 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 Access. As always, make sure you make a backup copy first before proceeding.
