I have a growing Access database. It's backend data is on SQL. The Frontend has the VBA programming, the Queries, the reports etc. Currently it is about 150 Megs (Frontend). When I do work on it, it balloons to about 350 Megs. I then compact and repair and it comes back down.
My question is, what takes up so much room? Do forms take up huge amounts of space, do queries, reports, the VBA itself?
Should I try and cut down on the amount of forms (Many times I have a main form that calls various popup forms)? Should I try to find unused VBA code and comment it out or remove it? Should I try to compress the number of queries I have?
Biggest thing that eats up space is images embedded in forms or reports....are you using any?
If not, then you might be carrying around some additional junk. The best thing to do is create a new db container and then import everything into it.
/decompile will also often help if the space being used is code related.