Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access Database Size Issue


My Access database suddenly increased from 3MB to 13MB. I stripped out half the forms and did a compact and repair but that didn't help.
Is there anything else I can do?

Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Whereas I can see your concern, 13MB is still a pretty small Access db.

Meanwhile ... do you have a lot of data in Local tables ... ?
And note that when you delete records in a table, whereas there are no longer 'visible', they do remain in the table until a Compact & Repair is executed.

Over what period of time did this increase occur?

What else might have changed ?
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Did you recently add images to your forms? That can cause bloating.
As the others have said, no real concern.  The limit on an Access db is 2GB.

If it's not a lot of new data in tables, then check your MSysResources table and see if it is storing images.
I couldn't figure out a bloat issue I had a while back and that ended up being the problem.
This table doesn't dump images if you drop 'em from the app.  You have to do it manually.
Everyone should check this table to make sure they aren't carrying a lot of excess junk.
Avatar of Murray Brown


Thanks very much