Results 1 to 1 of 1
  1. #1
    VariableZ's Avatar
    VariableZ is offline Partially Knowledgeable
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Location
    Georgia, USA
    Posts
    40

    Attachments Will Not Delete

    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.
    Last edited by VariableZ; 04-18-2016 at 02:10 PM. Reason: Additional pertinent information

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Delete does not delete records in evey table
    By LaughingBull in forum Access
    Replies: 5
    Last Post: 09-01-2015, 04:05 PM
  2. Replies: 13
    Last Post: 05-06-2014, 12:42 PM
  3. Replies: 2
    Last Post: 01-29-2014, 03:19 PM
  4. Replies: 2
    Last Post: 01-24-2012, 02:16 PM
  5. Trying to Delete record using delete query
    By MooseOTL in forum Access
    Replies: 13
    Last Post: 10-04-2011, 02:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums