Back end memory size

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Probably due to temporary objects
ie
using SQL instead of saved queries for Recordsource, rowsource

does not sound not normal to me

Pieter
 
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.
 
But it soon bloats to 11MB.
Click to expand...

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

John W. Vinson [MVP]
 
Back
Top