extract OLE bitmap from table and save as a bitmap file

[Brett Rawcliffe]

A client has an Access database in which they have been
storing photos in tables as bitmaps.
The database is 2 Gig's.
I have recommended that they use a link to a jpeg
instead, which is stored on the hard drive.

The problem is how to extract 000's of bitmaps from a
OLE field and save them on a computer as a bitmap file in
a batch process.
Any suggestion is appreciated

 

[Stephen Lebans]

Have a look here:
http://www.lebans.com/oletodisk.htm
NEW - Apr. 14/2002 A2KExportOLEtoJPEG.zip A2K ONLY! This version
saves the entire contents of a table containing OLE Object Images to
disk based Jpeg files. User selectable compression rate. Version 1.5

Use the A2KExportOLEtoJpeg above instead of these following older
versions!

SaveOLEtoBitmap.zip is a database containing functions to allow you to
save the contents of an OLE Field to a disk based Bitmap file.

SaveOLEtoBitmapAuto.zip is a database containing functions to allow you
to save the contents of an OLE Field to a disk based Bitmap file for the
entire table automatically.


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.