Why does my db grow to 200+mb

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

Guest

I have a db that I am working on creating, and as I am writing the code and
testing it I keep noticing that it get larger and larger each time I click my
import/parse/update button to process said code.

Is all of this getting stuck in memory and I somehow need to release it or
refresh it? If a manually run a compact and repair it goes back down to a
14mb db which is just about right???

Thanks-

Steve
 
I have a db that I am working on creating, and as I am writing the code and
testing it I keep noticing that it get larger and larger each time I click my
import/parse/update button to process said code.

Is all of this getting stuck in memory and I somehow need to release it or
refresh it? If a manually run a compact and repair it goes back down to a
14mb db which is just about right???

Thanks-

Steve
Click to expand...

Access doesn't release deleted space until you Compact the database.
Compact often especially if you are adding and deleting forms,
controls, etc.
 
Back
Top