[AccessD] Access 2007 - compacted

Jim,

You didn't say what version of Access.

I have seen a bug where I would start running something (it was long ago and my memory is failing) 
but basically if you watched the database in explorer it would just grow and grow and grow... IIRC 
it was code executing that triggered it.  At any rate I would have to go into task manager and stop 
it.  Decompile / compile / compact / repair and all would be right with the world including getting 
rid of whatever was in the "expanded" container.

It was always in very complex containers.

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 3/5/2013 9:33 AM, Jim Hewson wrote:
> 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?