You can use the Compact and Repair Database command to prevent or fix these problems. Address three different ways using which users can compact their MS Access Database, and what are their possible pros and challenges. Enterprise software performs business functions including order processing, accounting, and customer relationship management. Microsoft Access/Jet databases require routine maintenance to ensure reliability, integrity, and efficiency. The Compact and Repair Database command can also help improve the performance of your database.