General discussion
May 1, 2002 at 12:08 AM
sara l

OLE Images in Acess 2K Embedded->Link

by sara l . Updated 21 years, 4 months ago

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 discussion is locked

All Comments