What function does compacting an Access database perform other than reducing the file size?
Repairing the database
Database files can rise quickly as you use them, occasionally impeding performance. They can also sometimes become corrupt or damaged. You can employ the Compact and Repair Database command to prevent or solve these problems. The compact method does not compress your data — it makes your database file smaller by eliminating unused space. The Compact and Repair Database command can also help improve performance of your database.
For Further Reading Go To This Page https://support.office.com/en-us/article/compact-and-repair-a-database-6ee60f16-aed0-40ac-bf22-85fa9f4005b2