Access 2007 FAQ
How do I create a new database in the 2000-2003 MDB format? Access 2007 always wants to create a new ACCDB file format.
By default, Access 2007 creates new databases in the ACCDB file format. To create a new database in the MDB file format, first click the Blank Database button near the top center of the Getting Started screen. Access now displays the Blank Database task pane on the right side of the screen, as shown below.
Click the folder icon, shown above, to open the File New Database window. Next, click the arrow on the Save As Type drop down list and select either the Microsoft Office Access Databases (2002-2003 format)(*.mdb) option or the Microsoft Office Access Databases (2000 format)(*.mdb) option, as shown below.
Browse to a folder location to save your new database, enter a name for the new database in the File Name text box, and then click the OK button to return to the Getting Started screen. Finally, click the Create button in the Blank Database task pane to open your new database in the MDB file format.
Important Note: You won't be able to utilize some of the new features found in the ACCDB file format in your MDB database such as Multi-Value Field Lookups and Attachment data types.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page