Access MBD size increases heaps even though compacted

[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.

 

[David Ind]

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.

 

[Arvin Meyer]

A database may double, or even triple, in size during development.
Increasing 10 fold is unusual, and perhaps an indication of some corruption.
I'd either decompile:

http://www.mvps.org/access/bugs/bugs0008.htm

or import all the objects into a new empty database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access