I wonder what makes my application inflate.
Fortunately MsAccess compresses the file automatically when I close it, but
still I wonder,
what makes it inflate in the first place.
At this stage of developing it's size is about 4 MB.
But while using it I can easily see the size increase to 12 MB or more.
When I close it it still becomes a touch bigger and then after a short while
access compresses it again to 4.
Is this behaviour absolutely normal
or are there flaws in my design?
What kind of things have an influence on inflating through using?
By the way, I use 2007, but the app is still of type 2003.
Recently 2007 could not compress it further than 7 MB, but when I opened it
in 2003 it could be compressed to just under 4.
Back in 2007 it stays that way. Only slowly getting bigger again.
Who wants to explain this to me?
Thanks
Michiel