ADP file growing rapidly

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!!!!

Ted
tk3Asked:
Who is Participating?
 
shanesuebsahakarnConnect With a Mentor Commented:
Hmm, that could be it. Out of interest, if you delete the gifs and then compact/repair, how big is the file?
0
 
shanesuebsahakarnCommented:
Decompiling will increase the file size in many circumstances.

Do you have any embedded images or OLE objects? That causes increases in mdb files, I don't know if it applies to ADPs as well.
0
 
ragoranCommented:
Just to be sure, when you say decompiling, you do mean that you started MSaccess with the /decompile switch on the command line ?
0
 
tk3Author Commented:
I have an 18 KB .gif file which I use in several of the reports (a total of 7 times).

That's correct on the decompile question.
0
 
tk3Author Commented:
You got it! I tried re-sizing the .gif image outside the project and it made a huge difference.
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.