I am using MS Access 2003... we have a few (about 8 reports) that I had linked our logo within the report... the DB file size was about 50MB. For various reasons I wanted to embed the 18KB graphic into each report. After doing that the DB size increase over 2x to 110MB! I tried:
- Compact and repair
- De compile and recompiling
- Creating a new DB and importing all my tables and forms
All had zero impact on the DB size. I remove the embedded images and DB size was back down.
How can 8, 18KB image cause the DB to double in size!??!?! Aside from linking is more efficient way to embed images aside from the graphical properties of the image as "embedded"?