inflating front end

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

Re: inflating front end

On Dec 4, 7:06 am, "Michiel Rapati-Kekkonen"
wrote:
> 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

This is normal behavior. In my experience, working on form and report
design will especially add to the bloat, but it is easily remedied by
compacting. Also, if you are deleting records in a table the space
occupied by the deleted records will persist until you compact.

A few MB is nothing to worry about. Compact often is the best advice I
can offer.