Convert OLE Object to hex (1 Viewer)

asawyer13

New member
Local time
Today, 03:35
Joined
Apr 3, 2011
Messages
4
I have a field in my Access 2003 database that's an image. It shows up as OLE Object.
I need to be able to have another field that has the hex representation of that image in it.
It would be great if I could create a function or a query so I could do something like:
update table1 set hexfield = hex(imagefield) where flag = 1

Is this possible?
Thanks in advance.
Alan
 

asawyer13

New member
Local time
Today, 03:35
Joined
Apr 3, 2011
Messages
4
Not sure why it would really matter to you, but I can tell you why, in case somehow it changes anything.

I am using ADODB in RealBasic to read from the Access DB. RealBasic seems to have an issue retrieving OLE Objects and Memo fields. I go around the Memo field issue but can't see to find a way to be able to retrieve the OLE Objects. If I had a Memo field that had the text representation of the OLE Object, then I would be fine.
 

Simon_MT

Registered User.
Local time
Today, 08:35
Joined
Feb 26, 2007
Messages
2,177
Have you considered referentially accessing these images?

No storing them in the database.

Simon
 

Users who are viewing this thread

Top Bottom