Has anyone experienced extremely large (600+ MB) Access 2007 .mdb files ?

David Mujica

Last night I wanted to copy an Access 2007 .mdb file and the thing was 618 MB ! :omg: I know that there is no way there could be that much data, so I did a compact & repair and the size went down to 6 MB. The other interesting thing about this .mdb is that there is actually no user data stored in it. It contains just the forms, queries, reports, modules. It references the data tables stored in a separate .mdb via linked tables. What could have caused this to grow to such a large size ? I never had this problem with Access 2003. I really can't stand any of the Office 2007 products. X|

_Damian S_

Why is it so? Because Access doesn't do garbage collection or cleanup particularly well. Usually, your file will swell rapidly if you are creating temp tables through code or make-table queries. Since you say it's your front end, one way to combat this issue is to have it compact and repair on exit.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

Mycroft Holmes

This problem has been around for ages - I remember having a compact method in access 97, the user could check the size via a form and would decide when to compact the database. This is one of the (minor) reasons to move to a decant database platform.

_Damian S_

Mycroft Holmes wrote:

decant database platform

Is that one that you pour from a bottle? rofl...

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!