Export OLE embedded images to file

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

Hi,

I have an access 2000 database containing images embedded in an OLE field.
Since the database is growing, I would like to get the images out, and
store them in files instead.

I found a database called ExportOLEtoJpegVer15 on Stephen Lebans' website,
which effectively can export the pictures.

However, the exported result is not so great: the exported images are tiny,
and rough, while the originals are good resolution and clear.

Here's a link to an example export file, and the original:
Original:
http://users.telenet.be/a206457/AH-0011Borg.tif
Exported version:
http://users.telenet.be/a206457/AH-0011B.JPG

The original was retrieved from the database as follows:
- Open a form displaying the image
- Select the image control (single click!, otherwise the image editor opens)
- Copy to clipboard
- Paste in the windows explorer. This creates a scrap book file
- Open the scrapbook file (opens with Imaging in W2K)
- Save a copy (as tif, which is the original format).

I could do this for a few pictures, but the databases contains a few
thousands...

Is there a way I could programmatically extract the images, and keep size
and quality ? Either by changing Stephen's nice database, or by reproducing
my steps programmatically ?

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)