I have a db with a few fields of type Attachment, in which are generally stored single jpg image files. When I delete the records that these fields are in (with, say, a delete query), the records go away, but the size of the db only decreases by the size of the rest of the records, not the images. Compacting does not help. The only way I have found to reduce the size of the db after this is to copy the entire table elsewhere, delete the original table, and copy the table back. Obviously, this is less than ideal. Does anyone have a suggestion as to what I could do to make maintenance of these records easier?
Edit: Using Access 2010.