Handling Images

[FeliXus]

Hi I am using MS Access 2000 and handling Images with GIF format on
DB. My DB size is normally 35 MB and I have 300 GIF images and each of 2-3
KB. When I adding all images to DB, DB size is growing up to 145 MB??? I
have 300 Images and 300 * 3 Kb = 27.000 KB. ???

 

[Allen Browne]

As you discovered, embedding images in an Access database causes impossible
bloat.

The better solution is to store a link to the file instead of embedding it.
Details:
http://www.mvps.org/access/forms/frm0030.htm

 

[Arvin Meyer]

Hi I am using MS Access 2000 and handling Images with GIF format on
DB. My DB size is normally 35 MB and I have 300 GIF images and each of 2-3
KB. When I adding all images to DB, DB size is growing up to 145 MB??? I
have 300 Images and 300 * 3 Kb = 27.000 KB. ???

I store my images outside of the database with a pointer to them using the
Picture property of an Image control:

http://www.datastrat.com/Download/Picture2K.zip

MVP Larry Linson has an extensive website devoted to imaging here:

http://members.tripod.com/accdevel/imaging.htm

A list of some Microsoft articles can be found at:

http://www.mvps.org/access/forms/frm0030.htm

Stephen Lebans has numerous image utilities at:

http://www.lebans.com

and finally, an excellent ActiveX image control is available at:

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

 

[FeliXus]

Thank you very much for all help messages.