I have a database that saved pictures (some large) in various graphics
formats created by different programs. There are about 500 pics in the db.
I have created a new database and successfully moved all the data from the
old database into it, except for the pics. I want to store these on a
network folder and show them in the forms when the client's info screen
appears.

Is there a way I can automate the saving of the stored pics from Access 2003
to disk (either Win XP workstation C: drive or a Windows Server 2003 network
folder.

Thanks in advance.

Anthony,

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

then you could do something really simple like looping through a
recordset and saving each image to a folder and updating the path to
the file at the same time.

Thanks. I'll check out the code.




"(E-Mail Removed)" wrote:

> Anthony,
>
> start here:
> http://www.lebans.com/oletodisk.htm
>
> then you could do something really simple like looping through a
> recordset and saving each image to a folder and updating the path to
> the file at the same time.
> .
>