BMP Compression

E

eb1mom

I am reworking an old database with many embedded Bmp
images. I would like to make sure they are as small as
possible. Several are over 2 Mgs. Database will be used at
multiple sites so linking images just isn't an option. Does
anyone know of a good program to reduce BMP size without
losing too much quality? Thank-you
 
N

Nikos Yannacopoulos

I know one you can use to save them as .jpg at a fraction of the size
without significant quality loss. It comes free with Windows, and it's
called Paint!

HTH,
Nikos
 
D

Dirk Goldgar

eb1mom said:
I am reworking an old database with many embedded Bmp
images. I would like to make sure they are as small as
possible. Several are over 2 Mgs. Database will be used at
multiple sites so linking images just isn't an option. Does
anyone know of a good program to reduce BMP size without
losing too much quality? Thank-you

There's a point that may not be clear from the responses you've
received. Saving images in your tables in JPEG or another compressed
format -- as OLE Object fields --isn't going to save you any space.
That's because Access will always *also* store an uncompressed bitmap
version of the image, so that it can show it when the field is
displayed.

However, you can, with a bit of code, store just the raw image data in a
long binary field, and then extract it for handling as an image whenever
you need to display or edit it. I believe someone has already posted a
link to Stephen Lebans' site, which has the wizardry required for this:

http://www.lebans.com/loadsavejpeg.htm

I just didn't want you to overlook that.
 
Top