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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: