Access 2013 All-in-One For Dummies
Book image
Explore Book Buy On Amazon

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.

About This Article

This article is from the book:

About the book authors:

Alison Barrows is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18-year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30-year veteran of the computer industry and the author of over 20 books.

This article can be found in the category: