Automate saving pics from db to disk folder

[Anthony Fontana]

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.

 

[pietlinden]

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.

 

[Anthony Fontana]

Thanks. I'll check out the code.