Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
Contact Us
About Us
Member Login
Access 2010 FAQ

 

How do I create a new database in the 2000-2003 MDB format? Access 2010 always wants to create a new ACCDB file format.

 

By default, Access 2010 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 New tab on the Backstage view. Access 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 New tab. 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, Attachment, and Calculated data types. You also cannot create web databases in MDB file formats.

 

See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out

 

 

Back to FAQ main page