Save images stored in Access table

[Eugene via AccessMonster.com]

Is there any way to extract images saved in Access tables?
As far as I know, images are stored as an OLE object and can be shown on a
form in Access.
But how do I export these images to files on my computer?

 

[Stephen Lebans]

See:
http://www.lebans.com/oletodisk.htm
NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[ekim via AccessMonster.com]

Thank you Stephen.

Will need some time to sort out this stuff ))

 

[Guest]

Stephen,

What would be the practicle purpose/use of your solution?. I'm not sure I
need it, but do work with images in Access and simply wondered if it would be
of use for me. I don't quite understand why someone would need to extract the
images unless it is to maybe cleanup/shrink the database size?.

See:
http://www.lebans.com/oletodisk.htm
NEW - Feb 06/2006 ExtractInventoryOLE.zip A2K or higher ONLY! This
version saves the entire contents of a table containing OLE Objects to disk.
Does NOT require the original application that served as the OLE server to
insert the object. Supports all MS Office documents, PDF, All images
inserted by MS Photo Editor, MS Paint, and Paint Shop Pro. Also supports
extraction of PACKAGE class including original Filename. Contains function
to produce a full Inventory of the OLE field including LINKED path and
Filenames. Uses Structured Storage API's to read the actual contents of the
field
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Douglas J. Steele]

Shrinking the database is definitely a major reason, but another reason
would be because you no longer have the original image file anywhere, and
you want to be able to use it outside of Access.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Stephen,

What would be the practicle purpose/use of your solution?. I'm not sure I
need it, but do work with images in Access and simply wondered if it would
be
of use for me. I don't quite understand why someone would need to extract
the
images unless it is to maybe cleanup/shrink the database size?.