Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Oct 1, 1996



Building the Right Environment to Support AI, Machine Learning and Deep Learning

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 this field as an OLE field and in VB I use a Picture Box. My problem/question is that VB recognize longbinary while Access recognized Bitmap. But I want both application to be able to extract my picture file. So there should be two step, one is to convert from Access(Bitmap) into long-binary in the program. Second is that when I select a photo from Commond 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.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date