Binary Field from .mdb

[Randal Ferguson]

All,

Is there any way to write a program to retrieve a bitmap from a field and
save it as a separate .bmp file? Any sample code (VB, C, etc.) anywhere?

Thanks,
Randal Ferguson

 

[Joe Fallon]

Check Stephen's website.
He is the expert on images and Access.

http://www.lebans.com/loadsavejpeg.htm

 

[Randal Ferguson]

Joe,

Thanks for the reply. I'll check this out.

Randal Ferguson

 

[Exponent]

It depends how the image was stored.

If it is stored as raw binary data then you can extract the original data quite easily using GetChunk.


If it was stored using OLE Embedding then things are more complicated. You can't get at the original raw
data, but the image can be rendered to a metafile then saved as bmp, jpg etc. Note that any compression
in the original image (eg jpeg compression) has been discarded, so re-saving as jpeg will be lossy, and
any metadata (such as EXIF/IPTC) will be lost.

A solution based on this approach is available from Stephen Lebans' site:
http://www.lebans.com/oletodisk.htm