Export OLE embedded images to file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I have a database containing a lot of images embedded in a OLE field. Since
the database is growing, I would like to export the images to external
files, and uses them as such.

I found a nice database on Stephen Lebans's website (www.lebans.com) that
exports embedded images to files. Unfortunatly, although the images are
exported, they are of a poor quality, meaning:
- they are tiny compared to the original image
- they look all jagged

Here is an original image:
http://users.telenet.be/a206457/AH-0011Borg.tif
And this is how it gets exported:
http://users.telenet.be/a206457/AH-0011B.JPG

I can export the original good-quality images manually like this:
- Open a form that shows the images in a OLE field
- Select the image field (single click!, double click opens an embedded
image editor)
- Copy the field (Ctrl-c)
- Paste the field in a Windows Explorer. This creates a scrapbook file in
that directory.
- Open the scrapbook file. In W2K this opens the file in Imaging.
- In Imaging, select Save a Copy
- I can save it as a tif file then, with it's original resolution and
quality intact.

Although this technique is nice for a few images, I really can't start doing
this on the more than 4000 images I have in the database (it's a stock
management program I developed).

Can anyone help me here ? Is it possible to keep the original's image
quality with minor modifications to Stephen's database, of is it possible
to programmatically do what I did to extract the original manually ?

Thank you.

Geert Janssens
.

Relevant Pages

  • Re: [PHP] Re: how to display images stored in DB*
    ... Your claim is that in ALL cases using a file system to store images ... bitmaps in a database without a damn good reason, a bad practice, yes. ...
    (php.general)
  • Re: [PHP] Re: how to display images stored in DB**
    ... for storing images is "bad" practice. ... "Bad" practice or "good" practice depends upon the needs and one's perspective of the situation. ... If you were to talk to the average computer user; or to the average investor who invests in technologies; or to the businessman who is paying the bills for programmers to build the product while trying to make money at the same time; they all might have different opinions as to the quality and state of software. ... If you assume that you have one database supply all the images to all ...
    (php.general)
  • Re: bound object frame: picture
    ... Please let me respond to your critique and hopefully help Bob along the way. ... generates can be very large when they contain images. ... Print event NOT THE FORMAT EVENT. ... your entire database will stop working when you get about 100 pictures ...
    (microsoft.public.access.forms)
  • Re: Filestream Error...
    ... >> I have a list of products in with images stored in a SQL Server 2000 DB. ... which opens another FileStream and keeps it open until ... > You should, however, definitely use a using statement for your database ... > connection:) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ListView - Caching Thumbnails?
    ... The program just will yield some odd results if they do (which I figure they can deal with if they are monkeying with the database;). ... Access databases fill the middle ground I guess but still, you can edit XML by hand. ... The underlying goal here is to create an interactive anatomical atlas program using high resolution images. ... Then I go back to school ). ...
    (microsoft.public.dotnet.languages.vb)