What causes bloating of .mdb files?
Posted on 2009-04-22
I have an Access2003 database with about a dozen tables, at least one of them some 250,000 rows of fields and several other tables with 3,000 rows. Each time I use the database I notice that the size seems to gradually increase. When I run "compact and repair" the difference in size is dramatic (from 300,000KB to 70,000). I'm certain that it runs faster at the smaller size.
What is likely causing this bloat? Do you recommend that I encode "compact and repair" into the code for my "Exit Application" button? I need some experienced advice.