Access MBD size increases heaps even though compacted

  • Thread starter Thread starter Nicola
  • Start date Start date
N

Nicola

Hi everyone,

I have a small database (2Mb) that is increasing to > 20
Mb each time I add new code. I'm doing the compact and
repair frequently - doesn't reduce by much.

Yesterday I created a new database and copied everything
over and it came back to 2Mb, but has jumped back to >20
Mb now that I need to add code more to it.

I am using ADO recordsets, but close and set to nothing
in each procedure.

Any other suggestions?

Many thanks,
N.
 
Nicola said:
Hi everyone,

I have a small database (2Mb) that is increasing to > 20
Mb each time I add new code. I'm doing the compact and
repair frequently - doesn't reduce by much.

Yesterday I created a new database and copied everything
over and it came back to 2Mb, but has jumped back to >20
Mb now that I need to add code more to it.

I am using ADO recordsets, but close and set to nothing
in each procedure.

Any other suggestions?

Many thanks,
N.
Click to expand...
 
Back
Top