storing images

How do you store images in an access database. e.g JPeg of a person

You don't! You should avoid storing the image in the mdb file - this leads
to bloating. A better way is to store the path of the image and then use
code to display the image on the form. Check here for a more detailed
explanation of the problem and links to sample solutions:

http://www.granite.ab.ca/access/imagehandling.htm


--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Chris wrote:
How do you store images in an access database. e.g JPeg of a person

In your table, choose OLE Object as the record type. Then in your data,
right click on the field and choose Insert Object. Select choose from file
and be sure to check the box to link (instead of embedding the file). I do
not know your purpose of doing this but please note that your database can
grow exponentially when inserting object.

Hope this helps.



"Chris" wrote:

How do you store images in an access database. e.g JPeg of a person