compact database in 2007

P

pelican

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
 
P

pelican

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