devxlogo

Retrieving Binary Objects

Retrieving Binary Objects

Question:
I am using VB together with Access. What I want to do is to include photo into my form. In Access table, I declare thisfield as an OLE field and in VB I use a Picture Box. My problem/question is that VB recognize longbinary whileAccess recognized Bitmap. But I want both application to beable to extract my picture file. So there should be twostep, one is to convert from Access(Bitmap) into long-binaryin the program. Second is that when I select a photo fromCommond Dialog I could be able to save back into Access. So there should be another conversion.

Answer:
Take a look at the GetChunk function (and related functions such as AppendChunk). That’s the function that is used to extract the blob into a variable/control.

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist