Pictures in a database

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

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
 
Ivor Williams said:
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?
Click to expand...

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
 
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
 
Back
Top