storing pictures

[Matthew Ellis]

Is it possible, and if so, how can I store pictures in a table? I am trying
to design a database in which the user can select a picture from their local
machine or network, import it into the table, and use the picture in forms
and reports. What is the best way to go about this. I have created a table
as follows:
tblPictures has the following feilds
-PictureID (Primary Key)
-Picture (OLE Object)
Thanks

 

[Sal Rosario]

You got it. A user will need to do Insert...Object to input the picture into
the table. Just create your forms and reports that read this field.

Notice that if you are going to store lots of pictures in an Access database
you may lose performance and run out of storage space. One alternative would
be to store links to the picture files rather than the pictures themselves.
In this case, you would use a Hyperlink field type. Just make sure that the
pictures are in a folder accessible to all users.

Sal
www.cedrostec.com