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.