Working with pictures in a db

[Guest]

Hi.

Im soon going to have to add the capability to have digital photographs,
portraits, associated with people records on one of my mdbs and for the
pictures to appear on Forms and Reports.

This is brand new to me. Does anyone have any useful advice? Are there any
good links to useful web pages covering this?

I presume Ill have the users transfer the photos to a Folder and set up a
Form to allow them to record each photos location and unique identity in a
suitable field. Do I need a special type of field in the table, should I use
Hyperlinks between the fields and the photos? What about the size of the
digital photo - do I set this at the image taking stage or can I vary it at
the Form or Report stage?

Any initial guidance, or samples, would be appreciated. Im using Access 2002
on XP, networked.

Cheers, JohnB

 

[JohnB]

Hi.

No need to reply to this. I notice another post from Paul, identical to
mine, has been answered by Doug Steele earlier this morning. This sort of
coincidence has happened to me before.

Thanks to Doug from me. Cheers, JohnB

 

[Douglas J. Steele]

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the
Image control to a Bitmap file prior to printing. This helps alleviate the
"Out of Memory" error that can popup when printing image intensive reports.

 

[JohnB]

Thanks Doug. You must have posted at the same time as I sent my second post.
Cheers, JohnB