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
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