Image-fields in Access

[Matti Möttönen]

I have made a database and there is one field which type is OLE-object and I
want to fill it by some jpg-image. When I make a report, I can't see any
picture on the screen. Is it possible to put images to database so that
images are seeing in report when I print the report?

 

[Matti Möttönen]

.... to be continued ...

If the image type is bmp, there is any problems. How it is with jpg-images?

 

[Larry Linson]

If you store images as OLE Objects, the actual display will be done by
whatever imaging software you have registered for the file-type of the
image.

You might want to take a look at the sample database appropriate to your
version of Access (97 or 2000 and later) that you can download from
http://accdevel.tripod.com. They illustrate three additional methods of
handling images. The included article discusses all three approaches and
what to consider in choosing one.

You'll find information on how to convert an image to bitmap before
displaying it (necessary using Image controls in a Report to avoid memory
leakage) at MVP Stephen Lebans' site on the page
http://www.lebans.com/printfailures.htm.

Larry Linson
Microsoft Access MVP