When compacting and repairing a database, Access doesn't actually compact the current copy of the database, it just saves it as db1.mdb? Am I correct?
If so:
I am building an application which there will not be an admin present to compact and repair. I am using a function to this automatically at program start. How would I go about replacing the current copy of the application with the compacted one?
Compact and Repair Database (db1.mdb?)
August 11th, 2015 4:56am
See https://social.msdn.microsoft.com/Forums/office/en-US/bfa91c9e-eff9-47c6-97ad-3dc83ffe51b3/compact-and-repair-database-db1mdb for an identical question.
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2015 9:44am