Taking images out of a DB Table

[Brendan]

Hi
I have 600+ images in a database table. The DB file is growing.
I'd like to extract the images, save them individually in the same file as
the DB and name them with their part number.
Then link the pictures into the forms when needed.

Is there a convenient way to extract and save the images as .jpg files with
the correct part number? I hate to do it one at a time.

Thanks for any suggestions.

Brendan.

 

[Douglas J. Steele]

I think Stephen Lebans has something at http://www.lebans.com but I'm not
sure exactly which of his fabulous examples it is!

 

[Arvin Meyer]

The page at Stephen's site is:

http://www.lebans.com/oletodisk.htm

Another solution, although not free, is DBPix 2.0

http://www.ammara.com

which does it with a simple right-click, then choose "Save".
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Brendan]

Lebans' form worked WONDERFULLY. Access 2002, Win XP. It
took about 6 minutes to extract over 600 .JPGs, name them and put them in a
folder for use, including the time to download and unzip the file.
Thanks!