Save images stored in Access table

  • Thread starter Thread starter Eugene via AccessMonster.com
  • Start date Start date
E

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?
 
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.
 
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?.

Stephen Lebans said:
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.
Click to expand...
 
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)


efandango said:
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?.
Click to expand...
 
Back
Top