access db question

[esthera]

I have an access db that has pictures stored in it's oledb field.
Is there a way I can move them to a folder on my hard drive and just update a field with the name of the picture in the folder?

[slyfox]

yes, display them on a page, then right click and save, OR loop through table while saving it using the filesystem object, then/while saving it's destination and id or name in a field in the db

easy as pie, I think!

[esthera]

how would I loop through and get the values -- you mean I should just write an asp to take the picture and move it to a file and update the system?

[slyfox]

Yes, that's the one

[esthera]

are there any scripts out there like this??
how would I get the picture to save to disk?

[slyfox]

I will point you in this direction... I'm not sure if you can use the filesystem object to move images around but you can get it's file names to save to db

http://www.w3schools.com/asp/asp_ref_filesystem.asp

[esthera]

but it's not saved now as a file -- it's save as an oledbobject -- how do I convert it from teh oledbobject to a file?