Storing pictures in Access DB

[Tom]

Hi

I'd like to store a bunch of pictures as blob in a access 97 database. The
pictures are stored in a folder. Are there any examples available how to do
that?

Tom

 

[Roger Carlson]

Generally you don't want to store them in blobs. Access bloats too quickly.
The usual solution is to leave them in a folder and just store the path to
them. Then you can load them into a form or report when you need them.

On my website, see sig below, is a small sample database called
"Picture.mdb" which illustrates how.

 

[Tom]

I want to store the pictures as binary data type in a memo field. In a
second step, the binary fields shall be extracted again.

I saw an example how to solve this, but I can't remember where...

Tom

 

[Stephen Lebans]

See:
http://www.lebans.com/loadsavejpeg.htm
LoadSaveJpeg.zip contains a database demonstrating how to use the Intel
Jpeg library with Access. Jpeg files are stored in their original
compressed state within a Binary OLE avoiding the Ole object "bloat"
issue.

A standard Image control is used to display the contents of the field
containing the Jpeg file. The Intel DLL is used to load the contents of
the field directly into memory bypassing the need to create a temporary
disk file.

The contents of the Image control, containing any supported source Image
format, can be saved to disk as a Jpeg file.

Very large Jpeg files that could not be loaded into the standard Access
Image control directly can now be loaded through the Intel Jpeg library.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.