Compact and Repair In Access 2007
August 13, 2009 by Admin
Filed under Access Development, Database
For whatever reason I’ve never been sold on the new Vista Windows Office look with the Ribbons. If you ask me it just seems more complicated then necessary and the navigation seems to take up more room.
Does Microsoft understand that customers get reluctant to upgrade because they keep moving all the options and items around? Don’t they understand that customers don’t want to relearn a product that is already doing the job on it’s own?
Well anyways, on to the point of this topic. Compact and Repair in Access 2007. Where is it? Is it under ‘Tools/Database Utilities’ like it is for Access 2003? No!?!? Those options don’t exist in 2007. The most intuitive option or the closest option in 2007 is ‘Database Tools’. But is it there?! Of course not!
Select the Office Button
Ok I’ll save all of you the suspense. It’s in the ‘Office Button’ (The funny circle in the upper left side of the screen),
Select 'Manage'
Then select ‘Manage’
Select Compact and Repair
Then select ‘Compact and Repair’. And that’s it.
So, there you go. That’s where Microsoft put the all important tool! I can see that it “fits” there. But Microsoft at least provide us with some kind of cheat sheet as to where you moved everything.
