I’ve recently been cleaning out the log files of one of my old sites which are stored in an access database which was touching on the 150mb mark. As I’ve recently upgraded to MS Office 2007 (Thanks Work!) I’ve been scratching my head to find where the Compact and Repair option is in the new ribbon interface… Well I’ve finally found it.
Compact and Repair is now located under Office (Big round button top left) > Manage > Compact and Repair.
WARNING! – It’s temperamental and randomly deletes your database – so save as a backup before you do this (It’s a known bug by all accounts but very annoying).
Hope that helps you if you’re stuck with MS Access 2007!
L8R, Mark.








