CODEWITHSUNDEEP
vbams-accessattachment
wdews
wdews

Reputation: 352

Large ACCDB file after removing all attachments

My Access database was originally just short in size of the 2GB limit that Access allows. To reduce size, I went through and removed attachments. Unable to find a good automated way of removing all the attached files, I went through and manually removed each attachment by right-clicking each attachment field, "Manage Attachments", and clicked Remove for all files.

I haven't seen a reduction in my database's size since doing this. Is there a step I missed, perhaps? Is there a macro/query I could run to wipe all attachment data from the table I have?

Please note, I need to keep this field intact, just remove all attachment data. Thanks.

Upvotes: 1

Views: 1536

Answers (2)

Guest Mazen
Guest Mazen

Reputation: 1

It seems that Access keeps attachments cache stored in accdb even if you delete records that contains an attachments fields, so you need to make a fresh accdb file, and then import all tables from the accdb you already emptied from attachments

Upvotes: 0

Johnny Bones
Johnny Bones

Reputation: 8404

Take a look here. You can try putting some of your tables into a separate Access DB and linking them, which will allow you to get around the 2GB limit. Also, set your DB up to compact on exit, which should help to keep it under control.

Upvotes: 1

Related Questions