Pictures in a database

[Ivor Williams]

I have a large database with many records, each one includes a picture (jpg)
approximately 3.5kb. Obviously with many records, this creates a lot of
bloat. Is there an easy way to reduce the size of the pictures en masse or a
better file format to use for the pictures so as to reduce the size of the
database?

Ivor

 

[Sandra Daigle]

Hi Ivor,

Access/Jet is not very efficient when it comes to storing images. The best
alternative is often to store the path to the image instead of the image
itself. Check this page for the explanation of the problem and links to
various solutions:

http://www.granite.ab.ca/access/imagehandling.htm

 

[Arvin Meyer]

I have a large database with many records, each one includes a picture (jpg)
approximately 3.5kb. Obviously with many records, this creates a lot of
bloat. Is there an easy way to reduce the size of the pictures en masse or a
better file format to use for the pictures so as to reduce the size of the
database?

PictureMgr is a prebuilt free demo database that demonstrates how to display
pictures in Access, complete with all the code you'll need.

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Larry Linson]

The sample databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access. The article included in the
download discusses the problem of bloat (which only occurs with one of the
three approaches).

Larry Linson
Microsoft Access MVP