For Access 2007, the default file format is ACCDB. But, if most of the files will be used by prior versions of Access, it might be best to specify a 2000 or 2002-2003 MDB as the default file format. It is easy to set the default file format. And, if you need to specify a different file type, it takes only a couple of extra clicks to override the default selection.
Setting the default file format is accomplished in a few easy steps.
1. Open Access 2007, but don't open a file.
2. On the Ribbon, click the Microsoft Office Button.
3. Click Access Options, a button at the bottom right of the fly-out.
4. In the left pane of the Access Options dialog box, click Popular.
5. Under Creating Databases, in the Default File Format box, select the preferred default file format.
Of course, you probably want to confirm that the settings were saved as expected. One quick verification is to initiate the process for creating a new database. That opens a pane on the right and provides a default name for the file. Clicking the folder to the right of the filename opens the New Database File dialog box. The line Save As Type will display the default file format, including the version and extension, such as 2002-2003 format (*.mdb).
Was this article helpful?