Help my database keeps growing in size.

[GoinDeep]

I have created an Access 2000 database which is about 15 megs in size. but after an hour or two of generating reports it jumps to over 100mb. what could cause this? I can perform a compact & repair but this takes some time.

 

[Jacob Mathai]

compacting is the right thing to do.

You can set it to compact on close.

Tools/options/general tab/check box 'compact on close'