Removing images from Access DB via Update Query?

[zkrucz]

I have a DB with images loaded in attachment fields (up to 10 per record, and thousands of records). I need to create space in the DB and I would like to remove many images which are no longer useful using something similar to the update query. However, when I tried it using an update query, I got an error stating that the fields with multiple values (attachement: data, field name, type) cannot be updated or deleted.



Does anyone have any experience on how it can be done via another method?

[June7]

To programmatically extract images and save to folder location or to delete specific images requires VBA manipulating recordset objects. Review https://sourcedaddy.com/ms-access/wo...nt-fields.html

Can open a query that expands the attachment field so each attachment is displayed on its own row then manually delete records. However, trying this with a DELETE action SQL fails because of the multi-value nature of attachment field.

Advise to not store attachments in table, just store path to file in a text field. If each record can have multiple images then use a related dependent table so each path is a record. Even if using attachment field, 1 attachment per record would have made this purge much easier. Then entire record could be deleted.