Monday, August 2, 2010

Access 2010: Detect and Repair

Starting with Office XP, Microsoft introduced the Detect and Repair feature for all Office applications.  This is different than the Access Compact and Repair in that it detected and repaired problems with the Office application itself (Word, Excel, Access, etc.) rather than a particular file.

In a way, it was like launching the Office Repair from Control Panel > Add/Remove Programs, except it targeted just the application you launched it from.  If launched from Word, it would repair only Word.  If launched from Excel, it would detect and repair problems in Excel only.  If...well you get the idea.

Once launched, it brings up the Detect and Repair Wizard, which looks something like this:



In Access XP and Access 2003, Detect and Repair was launched from the Help Menu.



In Access 2007, they changed it to a more comprehensive utility called Microsoft Office Diagnostics, which is launched from Office Button > Access Options > Resources Tab > Diagnose.



As far as I know, however, the option is not available in Access 2010, either from the menu system or the Ribbon.  You can, however launch it in code:

Application.CommandBars.FindControl(ID:=3774).Execute

This will launch the original Detect and Repair.
 

If you want to add it to the Ribbon, you'd have to put the code in a function in a general module:

Function Detect_Repair()
Application.CommandBars.FindControl(ID:=3774).Execute
End Function
 
Create a macro that runs the function:
 

And lastly, add the macro to a custom group on the Ribbon.
 
.

5 comments:

Tricia said...

I have added an index to a database trying to learn how they work. I had no trouble clicking on Indexes and filling it out, my problem lies in using it. How do you actually use it? I would appreciate your help! THanks.

Tricia Z

Roger's Access Blog said...

@ Tricia,

Well, this isn't the best venue for support, however, I do have another post which addresses indexes here: http://rogersaccessblog.blogspot.com/2008/12/access-101-what-is-index.html

An index isn't something you use directly. An index is something the Access query engine will use to return records more efficiently.

Dan Knight said...

In an earlier post you referred to a split database on a SharePoint site.
Most of my databases (Access 03) are split. I'm now embarking on migrating these dbs over to A2010 and hosting them on Accesshosting. Is the concept of split db the same: upload both FE and BE to Sharepoint and then link the tables, or do I have to convert them to a single db?

Roger's Access Blog said...

You'll want to join the FE & BE together. There is no way currently to link a web database to a different BE.

Access Database Repair said...

I always used compact & repair utility to check & repair process. One day my access database get corrupted & compact repair was also unsuccessful to repair database. At that time I have used Access Repair Tool to repair access database. After reading your post I have got another idea to repair access database, surely I will try this in future. Thanks for sharing!!