Access 2000 database rapid growth
All you have to do is the following:


Across the Top of the Access Window, Click the File Tab
Click the Compact and Repair Button


I would not worry about growth because data insertion into MDB usually appends changes to back of the file. Garbage collection and space reusage is not a strong suit for MSAccess. To make matters worse, there is filesize limit (I think it is 2GB) on MDB files. This is why some migrate to SQL Server Express where SQL Server can be configured to perform automatic Compacting and Repairing.