Images Stored as Hexadecimal data in OLE

[abuaksham]

I am using Access as front end and SQL server as back end
there is a table that contains images in hexadecimal format , however in the access it appears in the linked table as OLE field that i am not able to open [ an error message is populating "A problem occurred while access was communicating with the OLE server or Active X control" ]

I need a way to be able to view the images in Access forms and reports
attached is a sample of the table

Best Regards.

 

[WayneRyan]

a,

Hope this helps:

https://msdn.microsoft.com/en-us/library/ms678200(v=vs.85).aspx

Wayne

 

[abuaksham]

The code was complicated for me to understand, however I copied the main two codes [GetChunk and AppendChunk] and used it , what it did was only copying the binary data from the oreginal field to another field but I am still not able to view the image !