Size of database with JPG image as an OLE Object

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
It is also better to create a small report containing the logo & use as a
subreport

Pieter
 
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.
 
Back
Top