How to Convert an Older-Version Access Database to Access 2013

Access 2013 uses the same file format as Access 2007 and Access 2010 for storing its databases, but previous versions of Access use a different format. You can tell what version a database is by opening it in Access and looking at the title bar. The title bar may display (Access 2000 file format) or (Access 2002-2003 file format) for an old format, or nothing or (Access 2007 - 2013) for the new format.

To convert a database from an older file format to the Access 2013/2010/2007 format, follow these steps:

  1. Open the database.

  2. Close any open objects.

  3. Click the File tab of the Ribbon to enter Backstage View, and choose Save As.

  4. In the Save As dialog box, below the Save Database As heading, select Access Database (*.accdb).

  5. Click the Save As button.

  6. Browse to the folder where you want to store the new version of your database.

  7. Enter a name for the database.

    Access creates a new database containing all the objects in the old database, stored in the new format, with the extension .accdb. Additionally, a message warns you that this new database can’t be opened in Access 2003 or earlier versions.

  8. Click OK.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.