Background image size blowout

[DanR]

Hi

I have a recurring problem when I add an image as a background to a form in Access 2000.

The graphics file may be 100k or 200k on disk, but when added, the size of the .mdb file blows out by as much as 10Mb!

As a result I gave up on it, and have a very functional, but boring looking application.

Any thoughts??

 

[Pat Hartman]

Change the PictureType from Embedded to Linked. You'll need to store the picture in the same directory as the db or in a consistant place or copies of the db won't be able to find it.

 

[DanR]

Thanks Pat

I can certainly do that, although I'd like to keep the number of required files to a minimum if possible

But is there another solution, or is this a known bug?

I can't believe that embedding an image would add so many times its own size to the db.

While writing this reply I just tried a quick test, and found that embedding a 15kb jpg image added over 1mb to the db.

cheers
Dan

 

[Rich]

Article ID: Q123151

 

[ElsVanMiert]

The reason for the bloating effect is the fact that ACCESS stores JPGS and GIF internally as BMPs.
Have a look at www.unsoftwareag.com/togwa.htm for alternative solutions.