Size of database with JPG image as an OLE Object

[Guest]

Hi

I had a database which was approximately 7mb after compact and repair.
I changed the image (company logo) on a report with a jpeg image which was
207kb. Now after compact and repair database size is 18mb. I have taken this
image out and the database has returned to 7mb.
Any thoughts as to why.
New Image is a better quality picture of the company logo.

Thanks

Richard

 

[Guest]

Yes, database bloating is a common problem when embedding images. This is
why you should not embed images but rather simply store their path/filename
and populate the control on the fly. You should create a simple config table
where you could store the path to your company logo and then populate its
path in your report and forms on the fly.

Also, based on what I have been told, I think if you really require
embedding an image you are best using MS format (BMP). But maybe someone
else could confirm or negate this.

 

[Pieter Wijnen]

It is also better to create a small report containing the logo & use as a
subreport

Pieter

 

[Guest]

Very True! This is equally true with forms. Create a form to house your
logo and then simply insert it as a subform when required. This way the
database only stores one copy of your image rather than a separate image with
each form/report.

 

[Pieter Wijnen]

Also it only gets rendered once in memory

Pieter