Pictures in Database???

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?

http://www.rogersaccesslibrary.com/d...e=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.

"Phil Rhynerson" wrote in message
...
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?

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

--
__________________________________________________ _____
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0 - lossless jpeg rotation, EXIF, asynchronous


"Phil Rhynerson" wrote:
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?