How to compact the current DB

[Guest]

I have a database frontend. Despite the fact that all data is kept in a
backend, I still have the frontend grow in size over time. When compacted it
returns to its original size.

How do I compact my database as I run... like from the tools menu I can
compact the currently opened database. How do I do that from VBA in the
running frontend?

 

[Guest]

Sorry but you cant compct a database that is open, by you or by any other user.
So you cant compact it while running it.

 

[Van T. Dinh]

If you are using A2000 or later, simply use the Compact-On-Close option.