General discussion


OLE Images in Acess 2K Embedded->Link

By Sara L ·
I have a client's Access 2000 db with embedded OLEobject images (photos and scanned documents) that needs to have those images exported as jpeg files for which I can create links in the corresponding data fields. Can anyone suggest a way to do thiswithout a user interface for opening and saving each image (read that: I don't want to do it manually.)?

I began this project in VBA hoping to find a way of getting the image and saving it with a filename concatenated from the tablename, row and column name. The tablenames are short 4-8 char, the column names are also short 3-5 char.

Thank you in advance.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

OLE Images in Acess 2K Embedded->Link

by HeartyGuffaw In reply to OLE Images in Acess 2K Em ...


See Microsoft KB Q210486 at:;en-us;Q210486

The article talks about BLOBs. One of the KB's examples is a "WriteBlob" function, which is what you're trying to do.

You couldmodify their code to loop through your table and concatenate your row, column, etc. info to the file name. The only thing you'll have to be careful of is you may be working with different original ole data types (JPGs, BMPs, etc.) If you open the table containing the OLE objects, it should show the different data-types you're working with. If they are not all the same, you'll need to reference the ole object's CLASS property to write out the correct file extension.

Hope this helps.

PS. I'll bet that database you're working with is HUGE!!

Collapse -

OLE Images in Acess 2K Embedded->Link

by Shanghai Sam In reply to OLE Images in Acess 2K Em ...

I tried the code in a test database set up in the manner described on the MS site, with the exception that instead of the .hlp file, I used an embedded bitmap image, and named the file dbname1.bmp. These functions did not work. The resulting files could not be read by Paint or any other image editor, and Windows 2000 couldn't even display the thumbnail image.

Yes, the db is HUGE!

Collapse -

by Sara L In reply to OLE Images in Acess 2K Em ...

This question was closed by the author

Related Discussions

Related Forums