[AccessD] Access 2007 - compacted

I usually C&R every other day or so when I'm working on code.
I've been working on this project for three years and it has never gone
down so drastically.
I've done a /decompile in the past but never got a reduction like this.
John - it's Access 2007.
Yes, I've exported everything out and created a fresh container a couple of
times, but that usually only gives me a few MB back.
This just has me flummoxed.
Whatever the reason... I'm a happy camper!
Thanks for your thoughts.
Jim

On Tue, Mar 5, 2013 at 9:37 AM, Jim Dettman <jimdettman at verizon.net> wrote:

>
>  Sounds like the VBA project was out of whack...
>
>  Did you do a /decompile at any point or import into a fresh DB container?
> If so, all the compiled pseudo code was dumped.
>
> Jim.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
> Sent: Tuesday, March 05, 2013 09:33 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2007 - compacted
>
> I had something happen that I can't explain. I hope someone on this list
> could shed some light on it.
>
> I have a complex database, 77 tables (2 linked, 2 user system), 518
> queries, 161 forms, 146 reports, 29 modules and 2 classes and approximatel
> 42,000 lines of code.
>
> While I was creating this database the size increased.  The latest was over
> 92 MB.
> I was doing some trouble shooting because one query wasn't working
> correctly with one of the linked tables.
> I got an error message... stating it couldn't find a field in the query and
> then it shut down.
> I reopened the database did the usual - compile, saved, etc. I fixed the
> error and then the issue went away.
> Then I did a compact and repair.
> Everything is working, all the code is there, it's as if nothing happened.
> Great! I'm back in business.
>
> I checked the size of the it's down to 22.3 MB! How can that happen? - goes
> from over 92 MB to 22.3 MB.
> I'm happy the file size is down and everything works! It also seems to work
> faster.
> I'm confused.
>
> Can that be explained?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>