Retrieving Binary Objects

Retrieving Binary Objects

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.

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.


Share the Post: