Forum Discussion
Compact & Repair throws error saying file is in use
When trying to compact and repair any database created on my computer i get an error saying file is already in use. I have tried every possible way to fix this - reinstalled Office 365 tried multiple...
Nevermind I forgot to include the name of the DB. I think this worked it went from 18,560KB to 10,476KB
Clearly it did work! I use that approach to compact a BE database from the FE but it can be used to compact any database. The code can also be used to compact the current database to a backup file. Try changing strOldPath to the path of the current database and see if it works for you as well
NOTE: A minor modification will allow it to compact password protected databases as well
NOTE: A minor modification will allow it to compact password protected databases as well