How to compact the current DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

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