Database size grows very quickly

[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

 

[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

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

 

[Tom Wickerath]

Hi Chlaris,

Check out some of these KB articles, to see if any of them apply:

http://tinyurl.com/2dmpw


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[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

 

[Joe]

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

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

-jb