Database size grows very quickly

C

Chlaris

Dear all,

I have a database which grows very quickly to 1024 Mb.
If I compact, the actual size is only about 40 Mb.
What should I do to prevent the database growing quickly ?
Thanks.

Chlaris
 
P

pietlinden

Dear all,

I have a database which grows very quickly to 1024 Mb.
If I compact, the actual size is only about 40 Mb.
What should I do to prevent the database growing quickly ?
Thanks.

Chlaris
Click to expand...

Sounds like you're creating temporary objects and not compacting on
close. Compacting will recover all that unused space.
 
C

Chlaris

Hi Tom,

Thanks for the information.
It seems the problem with the MDE file.
I decompile the MDB file and create a new MDE, the database size is stable
now.

Chlaris
 
J

Joe

Chlaris said:
Dear all,

I have a database which grows very quickly to 1024 Mb.
If I compact, the actual size is only about 40 Mb.
What should I do to prevent the database growing quickly ?
Thanks.

Chlaris
Click to expand...
If you are using recordset edits (i.e. rs.edit, rs.update) rather than
SQL updates, you gain a lot very quickly

-jb
 
Top