Size of database with JPG image as an OLE Object

R

richard

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
 
D

Daniel

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.
 
P

Pieter Wijnen

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

Pieter
 
D

Daniel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top