Memory management, control, mdb file size

[shubhamgandhi]

What are some good practices to control the memory you block up with VBA.


For example, I declare objects, open connections, open recordsets, etc, but does that memory get freed again?

When I started the project I'm working on, my Access .mdb file was only 300kb, now its 13Mb!!!! (and its only 300 lines of code)
Everytime I run my code, I can see my .mdb file size grow by a few hundred kb.

So please help me out on how I should go about on maintaining my file size.

Thanks!

[orange]

Do regular Compact and Repair to free up space. Every time you delete a query etc Access keeps the space, until you do a compact and Repair.

[Mat2666]

This tip saved me about 180 Mb, thank you!