Pictures in Database???

[Phil Rhynerson]

Acess 2002...... I am loading pictures (to view in forms)
and My database grows incredibly large compared to the
size of the pics I put in it. My pics are 50-70 k big.
When I put in 100 it grows by 300 meg in size. Does
anyone know a secret or a solution?

 

[Kevin3NF]

http://www.rogersaccesslibrary.com/download3.asp?SampleName=Pictures.mdb

Don't store pictures in the db....store the path in a table, and the image
file in the directory

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Exponent]

When using 'OLE Embedding' certain OLE Server applications store the image data uncompressed, hence the
apparent overhead you are seeing.

As alternatives you can store the raw-binary image data in the database without causing this problem, or
work with external image files.

This article discusses the issue in more detail, and suggests code or component-based alternatives:

http://www.ammara.com/articles/imagesaccess.html