Converting OLE object (image) field to text field

[Guest]

Hi all

I understand that we should not store images into Access directly as it's not efficient. But I currently have a table that stores the actual image into Access using an OLE object field. I would like to convert this OLE object field into a text field which stores only the path and filename of the image. Does anyone knows how that can be done? I have 1000+ records which i need to convert. Tried looking for a path property of the OLE object but could not find any. Please help

Thanks in advance
yann

 

[Adrian Jansen]

If the tables now actually contain the images as OLE objects, you will have
to extract them as individual image files, and give them new names, and a
path to store them. It might be simpler to locate the original images used
to create the OLE fields and use them.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Hi all,

I understand that we should not store images into Access directly as it's

not efficient. But I currently have a table that stores the actual image
into Access using an OLE object field. I would like to convert this OLE
object field into a text field which stores only the path and filename of
the image. Does anyone knows how that can be done? I have 1000+ records
which i need to convert. Tried looking for a path property of the OLE object
but could not find any. Please help!

 

[Guest]

Hi Adrian

Thanks for reply. But may i know how can i extract the images from the table

thanks in advanc

yann

 

[Adrian Jansen]

Look around on http://www.lebans.com/oletodisk.htm for image handling stuff.
He is the master !

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control