Some Access Databases become nonfunctional when they hit the limit of 1.99 MB or let's just say 2GB. In this case, when you work in a data warehousing industry you know that, because of dependencies on other engines, this starts to create problems. In order to solve this, just open up the database and check Compact and Repair On Close
setting. Mostly, this check box is in File Optio
n Window. In short, just compact the Access database file, there is no need to create a new one or restore with a backup smaller file.
Compacting and Repairing is more like Shrinking a Database in SQL server which is not advisable because it kills performance of the indexes.
Edit this Article