Photos in jpg format

[eddy]

hi,
when storing photos in a access database (office 2000) it
looks as the jpg compression is ignored.
a photo compressed to level 2 giving a size of 20-40 kb
will take up 500-700 kb of space in the database.
the biggist problem though is when I want to mail the
photos. I get mails with 3 photos with a size of 1,0 to
1,3 mb. Poor recipient with a modem!!!!
Any suggestions or ideas?
Regards
eddy
thanks in advance

 

[Douglas J. Steele]

Yes, Access is quite inefficient at storing images. Check out
http://www.mvps.org/access/forms/frm0030.htm and
http://www.mvps.org/access/forms/frm0044.htm at "The Access Web" for
details.

Another possibility is to use the Intel Jpeg library. Stephen Lebans has a
demonstration of how to do this at http://www.lebans.com/loadsavejpeg.htm

 

[Exponent]

storing images in OLE fields in Access does bloat the
database considerably

This is not strictly accurate - storing compressed images using OLE Embedding or OLE Linking can cause
a very significant overhead, but images can be stored directly in OLE Object/long-binary fields as raw
binary data with no overhead compared to keeping them in the file system (and this can avoid several other
potential problems with OLE Linking/Embedding).