Access 2000 database rapid growth

We have an Access 2000 format database running in Office Access 2003.

We have a problem with the size when I merge the database; the size is about 250 MB. Two days later, the size has ballooned to about 750 MB.

How can I see where this increase in size comes from? Can I look behind the scenes in Access?

The database is running for a tennis club and our employees are working all day long with the database. Another programmer made the database and says it is common to see Access databases increase in size.

What can I do to alleviate this issue?

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.

StackExchange Database Administrators Q#21716, answer score: 4