compact database in 2007

G

Guest

In Access 2003 the earlier version, it is easy. You go to Tool, database
utility, etc.
Now I am using 2007. Under Database Tool, there is not a Utility button. Is
there a way to compact the database in 2007?

Thanks in advance.
 
J

Jeff Conrad [MSFT]

Follow these steps:
1. Make a back-up of your database first - do *not* skip this step
2. Click the Microsoft Office Button in the upper left corner
3. Click the option called Manage
4. Slide over to the right fly out and select Compact and Repair Database

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
G

Guest

Thank you very much. It worked.
I just installed Access 2007 and would never thought the "Compact" function
was moved to "Manage."
The new Help screen looks so different too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top