asked on Access Database Size Issue
Hi
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?
Thanks
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?
Thanks
DatabasesMicrosoft Access
Last Comment
Murray Brown
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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.
Jim.
Jim.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
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.
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.
ASKER
Thanks very much
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 ?