Compacting Problem

The problem that i am having right now is that I am doing a lot of deletions and need to compact the database while the program is still running but It will not allow me to do so. The only thing I can do right now is to compact it on form load.

I appreciate the help

j_lyver

I believe the compact/repair routines require exclusive access. If you close the database object, you should be able to do what you want.