Using Images Stored In Local Folder In Report

Hi All;

Any advice would be much appreciated….

I have a db of products which drives an ASP website, and includes links to images, which I have now stored locally (with the image path amended to point to the local images folder) along with the images folder containing all the images.

What I now need to do, is produce Access reports using these images, this I initially assumed would be a simple task, but hasn’t in practice worked out that simple!!

So, I now have local folder containing the images, and the products table with an Image field that stores the local path to the image – How can I now get the record and corresponding image to appear in my report? I’ve tried using an OLE field for the images, but this means updating each record manually (unless there is any way of updating the OLE field from the existing image path field??)

Am I missing something totally obvious here?

Thanks in anticipation!