I have created a Microsoft Access database, which keeps getting bigger as I use it. I compact & repair on close, and also while using it to keep the size down, but would like to know if there is an easier way to keep it compacted. The reports I run are based on multiple queries, which probably doesn’t help
