MDB Size After Compact & Repair

Following a "Save Operation Failed" error, I followed instructions found in another EE topic to decompile, re-compile and Compact and Repair the mdb.  This all seems to have worked fine, however, I notice that my mdb is now 1/2 the size it was previous to these procedures.  Having regularly compiled and C&R'ed the mdb, I wondered if this is reasonable... and why?  
dontheeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Yes ... definitely. It will shrink typically a LOT.

mx
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Why is because of the 'bloat' factor.  Adding, deleting objects in design, adding code and compiling code, adding data and deleting data ... all contribute to bloat.  C&R gets rid of the bloat.  This has been the case since Access 1.0.

And ... if you ZIP up an MDB ... the ZIP file is even smaller.  

mx
0
dontheeAuthor Commented:
thanks for the quick reply.  even if regularly compacted and repaired?  27mb to 13 mb.  is there an explanation why the regular c&r doesn't do the same as the decompile, etc?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

dontheeAuthor Commented:
and does that mean the proper procedure should be to decompile, re-compile then c&r?
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Normally, unless you encounter an error such as the one you did, only C&R s/b part of daily maintenance.

Actually, after you Decompile and then recompile ... the mdb will typically be larger.  Then, you do a C&R to bring it back down to the 'normal' size.  Almost anytime you compile, the MDB will get bigger ... due to the nature of how Compile works.

mx
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You really shouldn't decompile unless you need to do so, or at the very least make a copy before you decompile. You should, however, compact and repair regularly as mx said.

0
dontheeAuthor Commented:
one further comment then i'll accept your answers and up the points.  i have been watching the size of this mdb closely and its has been growing slowly in 20 something mb range.  as stated, i have been compacting and repairing regularly (with no recent previous errors) yet today, following the decompile, the size halved.  was something embedded that kept it up at 27mb that the decompile, etc today removed?  i still don't see why the regular, previous c&r'ing didn't produce the same size reduction.
thanks again.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
According the Michael (aka, Mica aka Micheal) Kaplan ...

"If it works, Don't fix it"

"was something embedded that kept it up at 27mb that the decompile, etc today removed?"

Could *definitely* be the case ... I see that happen often on my MDB's

mx

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dontheeAuthor Commented:
Thanks again, DatabaseMX.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.