[AccessD] images in Access

Hi John

You may wish to contact Shamil or Jim Dettman - they worked with the
same task 1½ years ago ... as quoted below.

/gustav


> Date: 2003-10-06 21:47

> I have a client that stored well over a hundred images in their db (employee
> pictures).  The db is bloated and slow, and I want to pull these images out
> and store them on disk.

> Does anyone have any code for reading the image out of a table, and saving
> the image to disk so that I can then replace the image with a link to the
> image?  Maybe even generate the path to the image and save that path back in
> another field?

<quote>

  It's not much as far as technique goes.  Since the OLE wrapper is not
documented anywhere, the only way to get a graphic is through a form
control.  From there, it's either sendkeys or OLE automation to control an
app (such as MS paint) to save the file.

  If you want a copy of what I sent to Shamil, just send me an e-mail
off-list.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net


> How about a working version?<g>
>
> I'll send it along in a few minutes.
>
> Jim Dettman
> President,
> Online Computer Services of WNY, Inc.
> (315) 699-3443
> jimdettman at earthlink.net


>     -----Original Message-----
>     From: AccessD-owner at databaseadvisors.com [mailto:AccessD-
>     owner at databaseadvisors.com]On Behalf Of Shamil Salakhetdinov
>     Sent: Monday, April 29, 2002 3:18 PM
>     To: AccessD
>     Subject: [AccessD] Getting picture part of OLE object...
>
>     Hi All,
>
> Is the subj an easy task, which solution I'm missing?
>
> - let's imagine I manually inserted a .bmp, .gif, ... picture into OLE
> field of a table.
>
> Now, I'd like to perform "stripping" everything but picture and
> saving this pictureinto a file, i.e. I need to restore the original
> picture file and I need to do that BY CODE.
>
> Is there an easy solution of the subj?
>
> TALIA for any hints,
> Shamil

</quote>