AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, September 13, 2007

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

 

Technorati tags: , ,

76 Comments:

Anonymous Anonymous said...

I'm not using 2007 yet (who needs that ribbon?), but AAD offers some help: http://www.aadconsulting.com/ribbon_swbd.html

Jay

3:03 PM  
Anonymous stema said...

ty man!! i was searching for the same thinghy and reached your blog: u helped! ty :)

12:05 AM  
Anonymous Anonymous said...

THANKS MAN! i FOUNDED ON ms SITE THE SAME ADVICE ANT THEN YOUR BLOGG HELPED ME. THANKS :)

5:37 PM  
Blogger http://lunken.wordpress.com said...

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...

2:44 PM  
Anonymous Anonymous said...

Thanks! Was having trouble to locate for this function and got the answer from your blog.

7:23 AM  
Anonymous Anonymous said...

Thanks for sharing! I googled and found this. Microsoft need heads up on it's help docs!

4:09 PM  
Anonymous vishal said...

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

3:51 PM  
Anonymous Anonymous said...

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.

12:51 PM  
Anonymous Suresh Jain said...

Thank you , I have been searching for this

6:57 AM  
Anonymous Chris Fujii said...

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

8:45 PM  
Anonymous Chris Fujii said...

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

9:26 PM  
Anonymous SharpEdges said...

Thank you!! I have been all over the Microsoft site and could not find an answer to this issue. Your site really helped.

1:21 AM  
Anonymous Anonymous said...

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!

11:16 PM  
Anonymous Anonymous said...

oh so grate, thank you

12:42 PM  
Anonymous Anonymous said...

Thanks for the tip!

9:02 PM  
Blogger Sonia said...

Your post has just saved me a lot of trouble.

Thanks a lot

1:11 PM  
Anonymous Anonymous said...

Was just looking for the Compact and Repair option, and google turned up your blog. Thanks!

6:03 PM  
Anonymous Anonymous said...

I would say that is a retarded place to put it, but that would be insulting to people with mental retardation.

11:05 PM  
Blogger Lucas said...

Thanks for letting us know! I too was looking around for it and the help guide didn't yield anything.

6:22 PM  
Anonymous Anonymous said...

Wow! Thanks so much. I was going crazy looking for that function.

3:39 AM  
Blogger Daniel said...

Thanks! You're the #1 google result for 'how do I compact a database in access 2007?' lol

9:46 PM  
Blogger Kevin Tate said...

I would have never thought to look there! Thanks.

11:01 PM  
Anonymous Jorge R. said...

Thank you!!

I tried searching by myselfe, using - of course - the built in help with no sucess ...

I would like MS pay us the rate of so many hours being their testers!!

4:49 AM  
Anonymous Zakariya said...

Thanks for this. I'd been looking for this and couln't find it until seeing your post.

What a strage line of thought to remove it from the 'Database Tools' section

3:52 PM  
Anonymous qgirene said...

and 2 years later a google search is STILL the only way to find that tool.. and your post was much more helpful than the MS result

9:39 PM  
Anonymous Anonymous said...

Thanks so much! I've been using MS Access since 2.0 and I just spent over an hour trying to figure this out and I also ran across the article you mentioned on microsofts sight. UGH! Anyways thanks so much!

5:27 PM  
Anonymous Anonymous said...

Thanks. It is May 2009 and this note via google helped me to find the compact/repair database option hidden under the unusual manage list.

9:24 AM  
Blogger David said...

Thanks for sharing such good information. It really helpful to every MS office user. But sometime
the data is badly corrupted then you are not able to repair your data directly. During that time you need access repair software that repair and recover your data.

1:18 PM  
Anonymous Anonymous said...

Thanks for saving me the next few hours, and some sanity!

11:45 PM  
Anonymous Anonymous said...

Thank you... June 2009... still does my head in this new menu... spent a while looking for the damned 'hidden' button.

7:45 AM  
Anonymous Anonymous said...

this new interface is silly. And Microsoft thinks that they are innovating...

3:09 PM  
Blogger Amanda said...

I'm not liking this 2007 version. Thank goodness I can google my question and I found the answer in your blog. Thanks Alex in Moscow!

11:12 PM  
Anonymous Anonymous said...

http://www.addintools.com/

there are 2003 menues for 2007 (and 2010 alpha)

even has an ribbon-customizer

1:23 PM  
Anonymous Anonymous said...

Thanks a lot.. very simple...

Wish Access 2007 menu structure was like the old version...

Must have been a Uni Graphic Graduate that desiged the new menus (*)_(*)

2:33 AM  
Anonymous Anonymous said...

Here's the thing... If MS wants to shuffle things around like crazy, you would think a simple "Help" search on "Compact and repair database" would return a hit on where the damn thing is now hidden!! Office 2007 is driving me insane. I once spent about 1 hour trying to find out how to drag a point on an Excel plot, only to find out that MS didn't think that feature was useful and decided to remove it from 2007. I guess they needed more computer resources for the 2 quatrizillion color gradients on those plots!

7:38 PM  
Blogger Mountain Heart said...

Love Google .. Love sites with easy clear answers. Thank you.

2:37 AM  
Anonymous Anonymous said...

Thanks Alex,

Millions of man-hours are wasted every day because users have a hard time finding commands they know exist.

8:36 PM  
Blogger sami said...

i was looking for this info, and i stumbled upon this blog, thank ;)

12:14 AM  
Anonymous Anonymous said...

Thanks a million times

10:02 PM  
Anonymous Anonymous said...

Thanks!!!

2:22 AM  
Anonymous Allen said...

Fantastic, works even if winzip is not installed. It would be ideal if the backup for either zip or mdb be compressed first.

6:16 AM  
Anonymous Anonymous said...

Ditto...same frustration on the MS site and not being able to find it myself. Thanks for the post.

12:20 PM  
Blogger Hozy Ali said...

thanks very much. I spent about 2 hours with no luck. But you helped. thanks again.

11:28 PM  
Anonymous mike said...

Thanks.. this helped..

and yes still not in the MS help for access. Generally, the movement of everything in office seemed to fix something that wasn't broken, but I guess everyone has to re-train to the benefit of MS..

2:10 AM  
Anonymous Anonymous said...

Thanks! I was wondering where that menu item went after they upgraded my Office version.

7:08 PM  
Anonymous Anonymous said...

Thanks

6:10 PM  
Anonymous Anonymous said...

The link you quoted at the end of your article is for the 2003 version. Don't blame microsoft for you misreading 2003 help to be related to the 2007 version.

10:32 PM  
Anonymous Goga said...

Thank you, you've just saved my working day...

12:53 PM  
Anonymous Brendan said...

Thanks! Got to love people that save us from MSFT

8:20 PM  
Blogger roboldham said...

yeh thanks for that - I am liking the transition to Windows 7 and DO like the ribbons but this was helpful thanks!

1:06 AM  
Anonymous Anonymous said...

Thanks for the tip! This was driving me nuts!

5:30 PM  
Anonymous Anonymous said...

Thanks man, I searched help in office 2007 but could not find it and then i found your article googing. Microsoft help is really crap!

Thanks for your article.

1:49 PM  
Blogger braddock said...

Your post has saved me a lot of trouble. Good Work

5:10 PM  
Anonymous Anonymous said...

thank you!

9:14 PM  
Anonymous Anonymous said...

Thank you

8:09 PM  
Blogger A.JANAKIRAMAN said...

Thank you, it is a great solution for me.

8:38 AM  
Blogger Sébastien said...

Thanks. MS Office 2007 is something really bad... Looks like innovation is not always a good thing ! Cheers.

3:11 PM  
Blogger babsbecca said...

Here's an interactive guide to find where 2003 buttons are in 2007; click "Start the guide"
Access>>>
http://office.microsoft.com/en-us/access-help/interactive-access-2003-to-access-2007-command-reference-guide-HA010238899.aspx?CTT=5&origin=HA010229584

Excel>>>
http://office.microsoft.com/asstvid.aspx?&type=flash&assetid=XT010149329&vwidth=1044&vheight=788

the rest>>>
http://office.microsoft.com/en-us/training/guides-to-the-ribbon-use-office-2003-menus-to-learn-the-office-2007-user-interface-HA010229584.aspx#BM1

9:20 PM  
Blogger Farid said...

same problem,
where is compact, your blog gave me the answer, thanks

5:01 AM  
Anonymous Anonymous said...

Thanks Man for the info...

4:57 PM  
Anonymous Anonymous said...

thanks for the help!

1:22 AM  
Anonymous Anax said...

Really great post. Microsoft tried to hide the option and you explored it... LOL

11:29 AM  
Blogger Lawrence Nelson said...

Thank you. BTW It's Nov 2010 and I found you blog post via google - it helped me to find where MS hide the compact/repair database option. It should be under the "Database Tools" tab.

-Larry-

3:09 AM  
Anonymous Anonymous said...

One more "thanks" from a savvy user who wasted a bunch of time looking for that hidden function.

11:27 PM  
Anonymous Anonymous said...

Thnxx it helped me

8:01 AM  
Anonymous Anonymous said...

Thank youn, it helped me a lot

11:40 AM  
Anonymous Anonymous said...

Thanks a bunch i lost credit on that and was wracking my brains about it!

4:40 AM  
Anonymous Anonymous said...

Thanks!!! This blog was the first thing that came up in google!! Apprecaite the help!

7:32 PM  
Anonymous Hamoud said...

Thanks for your help.

2:35 PM  
Anonymous Anonymous said...

I just had it installed on my work comp. I looked under the obvious choice "Database Tools". Not there. I google up where it's at, and find out it's in "manage". Um...what? I want to go back to a classic menu, but I'm going to suck it up and give 2007 ribbon a shot, even if I don't agree with it sometimes.

10:41 PM  
Blogger Prett said...

You can resolve almost all corruption errors with Compact & Repair utility. But in some severe corruption scenarios, you are unable to resolve corruption error with this utility. When the Compact & Repair utility get failed to resolve corruption then you should use Access Database Recovery Software to resolve corruption & recover corrupt access database even after severe corruption.

1:43 PM  
Anonymous Anonymous said...

thanks so much for this.. wasted so much time before. Great help.

12:55 PM  
Anonymous Anonymous said...

Thanks for your help. There was actually a time in the distant past when Microsoft published User Manuals that came with the software and gave meaningful help. Today, the "help" files that come with the software, in lieu of a real User Manual, would be an embarassment to any professional with a smidgen of personal pride in their work.

11:56 PM  
Blogger Kris toffersen said...

This comment has been removed by the author.

1:22 AM  
Blogger Kris toffersen said...

This comment has been removed by the author.

3:03 PM  
Blogger Kris toffersen said...

db file corruption you can use Access Fix Toolbox to get back your corrupt data. http://www.access.fixtoolbox.com/

3:07 PM  

Post a Comment

Links to this post:

Create a Link

<< Home