How to compact the current DB

R

RSunday

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?
 
O

Ofer

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.
 
Top