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?