I am developing an Access Data Project, and the ADP file is rapidly growing. It is now 29MB, and I only have about 15 forms, 5 reports, and maybe a few thousand lines of code. I compact the file every day, but that doesn't seem to help.
Any idea what is causing this and how to fix it?
I heard something about this being a problem in Access 2003 data files, so I created a new file (in Access 2000 format) and imported all my objects. This made no difference in the size.
I also tried decompiling and recompiling, but that actually INCREASED the size of the file slightly.
Help, it's taking over the known universe!!!!