Picture size explosion

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

I have an OLE object field in a form for pictures. I can
place 2 x 32KB pictures into the database only to find
that the database has increased in size by 2MB.

My first question is why the explosion in size?

Second question is how can I counter act the sizing
aspect. I need to keep the pictures. I tried compacting
and saved no room.
 
I have an OLE object field in a form for pictures. I can
place 2 x 32KB pictures into the database only to find
that the database has increased in size by 2MB.

My first question is why the explosion in size?

Second question is how can I counter act the sizing
aspect. I need to keep the pictures. I tried compacting
and saved no room.
Click to expand...

You answers will be answered at the following page at The Access Web:

Handle/Display images in forms/database
http://www.mvps.org/access/forms/frm0030.htm

:-)
 
Access is very inefficient at storing images. While the .JPG format
compresses, Access actually expands each image when storing.

The recommended approach is to store the images as files external to the
database, and just store a path to the file in Access.

See http://www.mvps.org/access/forms/frm0030.htm and
http://www.mvps.org/access/forms/frm0044.htm at "The Access Web" for
details.

If it's critical that the images be stored in the database, Stephen Lebans
has code that uses the Intel Jpeg library to avoid the bloat. Check
http://www.lebans.com/loadsavejpeg.htm for details.
 
Back
Top