I am building a small access application and would like to create a button that allows the user to repair and compact the database periodically. Ive tried using the DBEngine.RepairDatabase / DBEngine.CompactDatabase methods but they error out - saying the database must be closed. If this is the case, why are you able to repair and compact using Tools>Database Utilities>Repair(Compact) Database menu commands from an open database?<br><br>Thanks in advance<br><br>-jackerman
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Repairing and compacting using code 1
- Thread starter jackerman
- Start date
-
1
- #2
Good morning,<br><br>You might want to check out the thread:<br><br>97-How can I compact a database using code while the database is open?<br><br>I just answered a question in the thread, so if you have your topics sorted by date, it should be near the top.<br><br>Kathryn
- Status
Similar threads
- Locked
- Question
- Locked
- Question