Exporting attachments to a folder with code

[WineSnob]

I have a DB with an attachment field. The DB has quickly grown to 2 gig because of the attachments. I need to export all the attachments to a folder and the change the design to a hyperlink rather than an attachment. The table tblWO has 2100 records that have attachments. Is it possible to export all the attachments to a folder on the server using code? If so, can you provide a direction to where to find the code. The only way I can see is to open each record and save the attachment individually.
TIA

 

[NigelShaw]

Hi

Not sure how you would do this. In order for it to work, the attachments would all need have it's name in a field so it can be found and even then, how would you manage duplicate names?


Cheers

Nidge