MS Access Graphic fields

  • Thread starter BS Productions VP
  • Start date
B

BS Productions VP

Does MS Access allow different pictures to be placed into different
records. I need to make a dbase of Dahlias that I grow and would like
to add a pic of each into the individual record. MS Works database
program won't do it. It only allows you to place a pic that then shows
up in ALL records. If anyone knows that Access can handle this, I would
appreciate it.
 
M

MacDermott

Well, you CAN store pictures as OLE objects in an Access table, but that
tends to bloat the database quickly. As long as you don't need to display
multiple records at once (continuous form), you can store the path to
individual graphics files, and display the image at the path for each record
when you display the record...
 
L

Larry Linson

Does MS Access allow different pictures to
be placed into different records. I need to
make a dbase of Dahlias that I grow and
would like to add a pic of each into the
individual record. . . .
Click to expand...

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.

The methods illustrated use some VBA but do not require an "expert
developer"; in fact, much of the VBA code can be used without modification.

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.

Larry Linson
Microsoft Access MVP
 
Top