what causes database filesize to increase rapidly

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

Guest

I have a stand-alone tracking database on two separate networks. They are
identical, except for the facilities data. The one "application" will go
from 6MB to 131MB, while the other maintains around 7MB.

What would be causing this jump? The network administrator assures me
nothing is being done to it, but...

Thank you.
Drew
 
Local tables, every time you add data to local tables the size of the MDB
grow, when you delete the data the size of it wont get down, so it keep grow
until you perform compact and repair.
==========================================
Another reason, openning record set, look at this site

http://support.microsoft.com/default.aspx?scid=kb;en-us;289562
==========================================
You can probably search this Discussion group for other reason, this
question been asked before
 
Thanks for your help!

Ofer said:
Local tables, every time you add data to local tables the size of the MDB
grow, when you delete the data the size of it wont get down, so it keep grow
until you perform compact and repair.
==========================================
Another reason, openning record set, look at this site

http://support.microsoft.com/default.aspx?scid=kb;en-us;289562
==========================================
You can probably search this Discussion group for other reason, this
question been asked before
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
Click to expand...
 
To what degree do you have code that deletes records and/or builds temp
tables and then clears them out? Doing a regular compact & repair should
TCO the problem.
 
Back
Top