Store all your pictures in a common folder. Each picture will have an unique
path. Store the complete path in a text field in your table. To display your
pictures in a form or report, add an image control (see the toolbox). Set
the Picture property of the image control to the field that holds the path.

Steve



"Jay Oken" wrote in message
...
I would like to add a picture to a record but do not know the best way to
do it. From what I can see OLE gives the option to "link" to the picture
file rather than imbed the picture in the database which then bloats my
database. The "attachment" type field has a nicer interface when I put it
on a form but bloats the database. Is there a way to use the Attachment
field type but have it be a link to the picture.

Thanks,
J