Insert images into DB

J

JayTee

Hi all,
I am trying to create a rubber stamp database with the view of eventually
creating a catalogue print out.
I know how to build forms, tables, queries etc but how do I put all my jpg
graphics into the database so that I can see the graphic and not a link. I
am aware of the OLE object field but don't know how to use it I plan to
create categories so that I can show clients the graphics of what the stamp
will look like.
Any help on this would be appreciated.
Thanks in advance
JayTee
 
A

Allen Browne

See:
Handle/Display images in forms/database
at:
http://www.mvps.org/access/forms/frm0030.htm
for 4 ways to approach this.

Unless you have only a handful of low-resolution images, you cannot really
use an OLE Object field to store images, because the database bloats so
fast.

Access 2007 is significantly better, as it stores the compressed image, so
you can effectively store hundreds of images. But if you are storing
thousands, the link is the way to do it. Again, A2007 does this much easier:
the Image control has a ControlSource, so you can store the full path to the
JPG in a Text field and display it without needing any code.
 
Top