Extracting OLE Package Objects from Access

[btuttle]

Hi all-
I have received an Access database from someone who has asked me to retrieve all the photos stored in it (as OLE packages). I came across a post entitled "Extracting OLE to pdf" from March 5th 2006 and found a link to a dll and a mdb that will extract the photos, but it writes the jpegs with only there original filename (at least that is all I have been able to get it to do so far). I need to append some information from other fields in the database to identify the photos. I was hoping to use C# .NET, but would gladly use vba or something if that is the only way to do it. So far I have no problem connecting to and reading from the database in C# and vba, but I just can't figure out how to convert the Package Objects back into jpegs. Any thoughts would be greatly appreciated.

Thanks, Ben

[puppydogbuddy]

See if any of these links from Steve Lebans web site help:

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

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

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

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

[btuttle]

Thanks for the links. I eventually managed to get the images out and append the row id to the file name with a one line mod to the VBA included in the mdb at http://www.lebans.com/oletodisk.htm

The only shortcoming at this point is that the code seems to write the pictures to disk with a higher level of compression than they had to start with. I'd like to write the pictures to disk without increasing the jpeg compression. I am looking through the VBA to see if I can find a place to set this, it's a lot of code to wrap your head around though. If someone happens to know how to do this already and can share I'd appreciate it.

[puppydogbuddy]

See:

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

NEW - Apr. 14/2002 A2KExportOLEtoJ PEG.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