<div>
Decompiling will increase the file size in many circumstances.<br />
<br />
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.
</div>


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.

<div>
Just to be sure, when you say decompiling, you do mean that you started MSaccess with the /decompile switch on the command line ?<br />

</div>


Just to be sure, when you say decompiling, you do mean that you started MSaccess with the /decompile switch on the command line ?


<div>
I have an 18 KB .gif file which I use in several of the reports (a total of 7 times).<br />
<br />
That's correct on the decompile question. 
</div>


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.

<div>
You got it! I tried re-sizing the .gif image outside the project and it made a huge difference. <br />
Thanks!
</div>


You got it! I tried re-sizing the .gif image outside the project and it made a huge difference.
Thanks!

<div>
<div class="content wysiwyg-content">
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. <br />
<br />
Any idea what is causing this and how to fix it? <br />
<br />
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.<br />
<br />
I also tried decompiling and recompiling, but that actually INCREASED the size of the file slightly.<br />
<br />
Help, it's taking over the known universe!!!!<br />
<br />
Ted
</div>
</div>


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

ADP file growing rapidly

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.