I am having a problem when I need to compact a database... The thing is that, because my application has several forms, I have to give the user the opportunity to close the program whenever he/she wants, instead of having to go back to the main form.
I also have to compact the database whenever I pres the End button. The problem is that in the other forms I have datagrids connected to ADO Data Controls, and whenever I try to compact the database, a message telling me that the database is open or being used is displayed, so I don't know if I better get rid of the end buttons in the other forms, or at least only compact the database when i close the application in the main form.
I also began to think that I could put this routine when the program loads, but I believe that this could slow the application.