Access 2007 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.
The instructions for changing the default format differ for Access 2010. For more information, see Changing the Default File Format in Access 2010.
The instructions for changing the default format differ for Access 2010. For more information, see Changing the Default File Format in Access 2010.
Difficulty: Easy
Time Required: 10 minutes
Here's How:
- Open Microsoft Access 2007
- Click the Microsoft Office button. This button (shown in the image on this page) appears in the upper left corner of the Access 2007 window.
- Click the Access Options button in the lower right-hand corner of the pop-up menu.
- You should be viewing the Popular tab. Locate the "Default file format" entry under "Creating databases" in the middle of the screen.
- Select the pull-down menu next to "Default file format". If you would like to use ACCDB format, choose "Access 2007". Otherwise, if you would like to use an older format, select the appropriate version of Access.
- Click OK.
- New databases will be created using the default format, unless overriden by the user.
What You Need
- Microsoft Access 2007
