How to insert images in access table

[racheal.me]

Hi all,

I am using Microsoft Access 2002. I would like to know how to insert images in Access table and retreive those data & images using Report.

I did change filed as OLE object. And try to insert object.

But I doesn't show at report.

Is there any other way to insert images in the table?

Please kindly help me.

 

[Lister]

Not really sure if you can store the image in a table. What is best practice is to store the image in another file and store the link to the image as a string value in a table.

eg: S:\Database\BackendData\Images\Poduct10.gif

Then place the image field on your form or report, bound to the string value and call the image when you need to. This saves massive amount of space in your database table (remember they can't be bigger than 2gig) and its fast.
As you are only calling one or at least a small number of images at once.

If this sounds like a solution let us know and I can post a small example.

 

[Oldsoftboss]

Sorry for the rant in this link, but the guy was sending me PM after PM asking really dumb questions over and over, and not taking any notice of my advice.

http://www.access-programmers.co.uk/forums/showthread.php?t=126179

The attachment shows how to store the path and view / print.

Dave

 

[racheal.me]

Hi Lister,

I change data type of the filed that I want to insert images as "text". Then store data using "D:\\keys\prod1.jpg".

After that I create Report & place the those fileds that I want including images filed. Of course it only show the link .. but no image displayed.

I want in this format.

Prod name, Prod Pic, Desc, stocks

In report, I really need to display images of each individual product.

Appreciate your help.