MS Access Batch Remove Attachment

[ir0llDeep]

I'm attempting to script/somehow automate batch removing ~2700 different
attachments that have been added to a db that I manage. The records are
located in MULTIPLE fields (3 different ones within the table).

Background:
I previously attempted to just flat out delete records via row selection and
hitting delete. Following this, I'd run the compact and repair tool to get
rid of "bloat" but this did NOT solve my problem. When I go through and
manually remove all the attachments for a record, delete it, and THEN run the
compact and repair tool it works as it should to get rid of the "bloat". How
do I get started on automating this process?

 

[Tom Wickerath]

Perhaps this will help?

SaveToFile Method
http://msdn.microsoft.com/en-us/library/bb257443.aspx



Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________