Back end memory size

[Guest]

I have a split database that is used by 4/5 users constantly. After I
compact the back end the size is reduced to just over 1MB. But it soon bloats
to 11MB.

Is there any reason why it may do this so quicky?

 

[Pieter Wijnen]

Probably due to temporary objects
ie
using SQL instead of saved queries for Recordsource, rowsource

does not sound not normal to me

Pieter

 

[Guest]

Access needs a little room to grow. For example if you do a sort in a query,
Access needs some room to rack and stack records. Also if you are using
temporary or 'work' tables, this can cause a little bloat.

11 MB? Don't worry about it! If the BE grows to 11 MB and usually stays
around there, don't bother to C&R. It needs that 11 MB to work. Now if it
keeps climbing to something like 100 MB without a large amount of new data
added, then there's a problem.

 

[John W. Vinson]

But it soon bloats to 11MB.

Fear not. 11MB is *tiny*. You're limited to 2048MB; 100MB is not at all
unreasonable for a working database.

John W. Vinson [MVP]