Access 2010 uses the ACCDB format by default. In this article, we walk you through the process of changing this default setting for newly created databases.
If you are using Access 2007, the process is different. For more information, see Changing the Default Database Format in Access 2007.
If you are using Access 2007, the process is different. For more information, see Changing the Default Database Format in Access 2007.
Difficulty: Easy
Time Required: 10 minutes
Here's How:
- Open Microsoft Access 2010
- Open the File menu and select Options at the bottom of the list.
- You will now see the Access Options window (shown in the illustration), opened to the General tab. Locate the "Default file format for Blank Database" 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 2010
