Compact and Repair database Microsoft access 2010 step by step guide

Asked By Joby Mathias 50 points N/A Posted on - 09/22/2012

I just upgraded my Microsoft Office from 2003 to Microsoft Office 2010. I like the changes in the new version. As this is a complete new package and solution, I am quite lost when it comes to using the Microsoft Access. The interface has changed and there are a lot of new tools now. I want to compact and Repair my database in Microsoft Access 2010 and I seem can’t do it. I am totally lost. Can you provide Microsoft access 2010 step by step guide on how to compact and repair database?

• Status: Open
• Question Views: 925
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Odom Vemus 0 points N/A #146773

Compact and Repair database Microsoft access 2010 step by step guide

1. Instruct other users to close the database. You must be the only user with the database open in order to run the tool.
2. Click the Microsoft Office button.
3. From the Office menu, choose "Manage", then "Compact and Repair Database"
4. Access will present the "Database to Compact From" dialog box. Navigate to the database you wish to compact and repair and then click the Compact button.
5. Provide a new name for the compacted database in the "Compact Database Into" dialog box, then click the Save button.
6. After verifying that the compacted database works properly, delete the original database and rename the compacted database with the original database's name. (This step is optional.)

About Odom Vemus

Questions
2

Answers
50

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 09/22/2012
• Question Category: MS Access