Write OLE object containing bit map to BMP file using Visual Basic

I have a database table with OLE objects holding BMP files.

Using DAO I can read the object into an Obejct variable and see the data as obj.value and the size as obj.FieldSize.

When I use "put" or "write" to dump the data to a file I get a different file size and I cannot view the picture.

Can you tell me what is the easiest way to write out the data to a BMP file?
valerieschupbachAsked:
Who is Participating?
 
valerieschupbachAuthor Commented:
I found a solution myself at:

http://www.ammara.com/access_image_faq/read_write_blob.html

However my error was to load the bmp file through InsertObject rtaher than FileToBlob; as a result running BlobToFile will not reproduce the original image. So you have to use FileToBlob and BloToFile in conjunction for it to work well.
0
 
valerieschupbachAuthor Commented:
How can I close this question myself?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.