Extract OLE Object from an MS Access database

Lebans has an updated verson released 07/23/2009 which should have corrected most of he bus in the earlier release.
               See   http://www.lebans.com/oletodisk.htm

That link is the same link i put on my post =(

If the new release has the problem you described, Picture may be a reserved word.  Why can't you just rename the OleObject in your table to Photo or something similar?

How can you rename that? it is the object name how can i rename it?

????
Place your Access table in design view, go down to the ole object field, rename it and save.

puppydogbuddy I'm sorry if what i'm about to write is not what you want to see but do you have any clue what i'm asking here?

It has nothing to do with the data type, it is set to OLE Object. Hence the format of the that Ole Object can be different. Aside from MSPhotoEd.3 can be Picture, Word Document, pdf, VSD, PPT and soon on... once the OLE Object is present on the database meaning on the table you can export it to the format stored. It can not be renamed or alter after is there.  

OK, now I understand. you want to extract the MsPhotoEd.3 object it its native format from the program it was created, and Lebans has not provided support for the MSPhotoEd.3 object.  That is not what you said in your original post.  

ok Lebans supports MSPhotoEd.3 what he does not support is Picture.

See this Link:
                http://www.sobolsoft.com/accessimage/

Before using, you should contact the vendor and make sure the product supports extraction for the objects you need.

It does not work everything gets extarcted as a dmp. i already try it

Have you looked into MS ACCESS 2007 at all?  It supports compressed storage of images in their native format on a go forward basis.  Existing images remain as ole object  type.
see this link  http://blogs.msdn.com/access/archive/2006/04/25/better-looking-forms-reports-faster.aspx

MS Access 2007 does not work! it works only if you start fresh using it not for older mdbs.

Just double checking:
1. Lebans says "It (his ole to disk utility) will work for any Image file format that you can see a preview for within a Bound/Unbound OLE Frame control". And you can not see a preview of the PhotoEd3 picture object within a Bound/Unbound OLE Frame control?

2. Did Lebans code extract the target ole object to disk in any file format or did it bypass the target ole object entirely?  The reason I ask is that there are file converters that will convert an EMF (enhanced meta file format), for example, to the desired format.
           freeware image format converter:  http://www.irfanview.com/

bypass the target ole object entirely

does this tool reads access databases and extract images?

No, does not convert OLE....but I may have found a solution for you.  See if you can work with the code provided in the second link below:

see this link:
        http://jvdveen.blogspot.com/2009/01/ole-and-accessing-files-embedded-in.html
        http://jvdveen.blogspot.com/2009/02/ole-and-accessing-files-embedded-in.html

Have a look at this post,
Jim Dettman have made a little program to do this,
you can email him, and he'll send you a copy (I did a while ago, and I got it).

https://www.experts-exchange.com/questions/20710263/Extracting-Images-from-object-field.html#9168456

jaffer

this is an abstract from that link:

JDettman said:
"What kind of images are they?  I have a small sample MDB that will do .BMPs.  The technique used can be adapted to other types"

jaffer