Storing JPG image in database

[Eric]

Hi,

The way the image is stored in the database is using a OLE
field which you must create in your table to store the
image. OLE fields basically store binary information into
the database; which essentially means you could store any
types of files into it.

In order to select what image is to relate to what record,
you'll have to use a dialog control (or some other method)
on your form. Link the dialog control with the OnClick
action of a command button somewhere in your application.
Finaly insert that image into the image box.

Regards,
Eric

 

[Larry Linson]

There are example databases illustrating three approaches to handling images
in Access that you can download from http://accdevel.tripod.com. There are
samples of all three in the forms and code, a guide to the databases, an
article on considerations in choosing which to use, and even some public
domain JPG images for testing.

Larry Linson
Microsoft Access MVP