I recently converted to access 2007 from access 2003. Before I converted to access 2007, my .mdb was 2mb after compact and repair. Now my frontend has bloated from 2mb to 10mb - after doing some non major modifications. When I try to compact and repair the .mdb, the best it can do is 10mb. But, if I create a backup, the backup is 2mb. Why is this?
I took the backup of 2mb and I opened the file, then compacted and repaired it. After this action the database doubled in size to 4mb. What is the issue here?