Compact database in Access 2007
I am not a frequent Access 2007 user yet, but using it from time to time. And always wondering – why do we get such a non-trivial menu (or ribbon) structure. Today I wanted to compact database. And I was not able to find such button. Same time I remembered that I had already looked for it, and had found, but no luck today. Google always helps in such cases, this time I found a tip from Tom Wickerath, Access MVP:
Click on the round Office button thingy that you should see in the upper left corner. Then click on Manage in the list. You should see Compact and Repair Database at the top of this listing.
Why it there??? Several versions it was in Database Utilities, and now it get hidden in other place. If it was important to have it in Manage menu – I would jut put it in 2 places, with respect to former Access users…
BTW, I also searched at Microsoft site and only advice I found “On the Tools menu, point to Database Utilities, and then click Compact and Repair Database/Project”
posted by Alex Dybenko | 23:05
18 Comments:
I'm not using 2007 yet (who needs that ribbon?), but AAD offers some help: http://www.aadconsulting.com/ribbon_swbd.html
Jay
ty man!! i was searching for the same thinghy and reached your blog: u helped! ty :)
THANKS MAN! i FOUNDED ON ms SITE THE SAME ADVICE ANT THEN YOUR BLOGG HELPED ME. THANKS :)
I was struggling with the same issue... I do hate the ribbon structure. Thanks man for the tip...
Why hide it behind a round button??? It's as smart as to have to press the start button to turn off the darn machine...
Thanks! Was having trouble to locate for this function and got the answer from your blog.
Thanks for sharing! I googled and found this. Microsoft need heads up on it's help docs!
Very good article for using compact and repair utility in help in Microsoft Access. It helps me to solve several. If data corruption is extreme and compact and repair utility not able to repair then you can use access repair software. For for information http://officerepair.wordpress.com
Thanks
Thanks, you've really helped me.
Ive used Access v2 but it wasn't until I found your article that I could find the Compact and Repair.
Thank you , I have been searching for this
Just so everyone knows, you can actually add it to your Quick Access Toolbar by doing the following:
Click the Windows circle, Access Options (at the bottom right of the menu), Select Customize and change the "Choose commands from:" dropdown to "All Commands", navigate to Compact and Repair Database, click the Add button to add it to the "Customize Quick Access Toolbar" list.
This puts the Compact and Repair button in the same toolbar as the save, undo, and redo buttons.
Hope this helps,
Chris
Also, if you program in VBA, I just found that you can program a button to run the following command:
SendKeys "%(FMC)", 0
This command does the keystrokes automatically for you so you don't have to navigate anymore. Poster said that it's worked for him sometimes. This is from www.ittooldbox.com (a great site btw).
Again, hope this helps.
Chris
Thank you!! I have been all over the Microsoft site and could not find an answer to this issue. Your site really helped.
Hi all,
this is indeed a very good question? I am not a person who is against changes, but today I actually wasted a lot of time until I found the solution in this website. Just imagine, next time you buy a car you find the parking breaks underneath your seat and wonder what's making such a pressure when you drive over hump!
OK, anyways, Microsoft's official response is Tools -> Database Utilities -> Compact and repair database, and it makes me sick!
oh so grate, thank you
Thanks for the tip!
Your post has just saved me a lot of trouble.
Thanks a lot
Was just looking for the Compact and Repair option, and google turned up your blog. Thanks!
I would say that is a retarded place to put it, but that would be insulting to people with mental retardation.
Post a Comment
Links to this post:
Create a Link
<< Home