Convert an Access Database | CustomGuide

Convert an Access Database

How to Convert an Access Database

Convert an Access Database

If you're working with a database created in a previous version of Access, you can convert it to the 2007/2016 file format to take advantage of the new features. You can also convert from the Access 2016 format to older versions of Access.

  1. File tab.
    Convert an Access Database
  2. An Access 2016 file (.accdb) can only be opened in Access 2007/2016 and not earlier versions of Access so make sure everyone who uses the file is running the correct version before you convert it.

  3. Save As.
  4. Not all Access 2016 files can be converted to an earlier format. If the database contains new 2016 features such as attachments, multi-valued fields, offline data, or links to some external files, Access may not be able to convert the file.

  5. Click the Save As button.
    Convert an Access Database

    If you have any open database objects, you'll see a message telling you to close them. Click Yes. If Access is unable to convert the file, you'll also see that message at this point.

  6. Save.
    Convert an Access Database

A copy of the database is made and opens, while the original database is closed.