Storing JPG image in database

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
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
 
Back
Top