How to Convert a Database to Access 2010 Format

When (and When Not) to Convert an Access database to ACCDB format

Access Database Screenshot

Both Microsoft Access 2010 and Access 2007 create databases in the ACCDB format, which was introduced in Access 2007. The ACCDB format replaces the MDB format that Access used before version 2007. You can convert the MDB databases that were created in Microsoft Office Access 2003, Access 2002, Access 2000 and Access 97 to the ACCDB format. Once the database is converted, though, it cannot be opened by Access versions earlier than 2007.

The ACCDB file format provides a number of enhanced features over the older MDB format. A few of the enhanced features of the ACCDB format in Access 2010 are:

  • Multivalued fields
  • Data macros
  • Publishing to Access Services
  • Encryption improvements

This article walks you through the process of converting an MDB format database to the new ACCDB format in Access 2010. The process for converting in Access 2007 is different. 

How to Convert a Database to Access 2010 Format

The steps to converting an MDB file format to ACCDB Database file format are:

  1. Open Microsoft Access 2010
  2. On the File menu, click Open.
  3. Select the database you want to convert and open it.
  4. On the File menu, click Save & Publish.
  5. Select Access Database from the section entitled "Database File Types."
  6. Click the Save As button.
  7. Provide a file name when prompted and click Save.

When Not to Use the ACCDB Database

The ACCDB file format does not allow replication or user-level security.

This means there are occasions in which you should use the MDB file format instead. Do not use ACCDB format when:

  • You need to share the database with anyone who uses Access 2003 or earlier
  • You need to use replication
  • You need user-level security
Format
mla apa chicago
Your Citation
Chapple, Mike. "How to Convert a Database to Access 2010 Format." ThoughtCo, Sep. 16, 2017, thoughtco.com/convert-database-to-access-2010-format-1019939. Chapple, Mike. (2017, September 16). How to Convert a Database to Access 2010 Format. Retrieved from https://www.thoughtco.com/convert-database-to-access-2010-format-1019939 Chapple, Mike. "How to Convert a Database to Access 2010 Format." ThoughtCo. https://www.thoughtco.com/convert-database-to-access-2010-format-1019939 (accessed November 18, 2017).