Change the default file format

When you create a new, blank database, Access asks you to name the database file. By default, the file is given the ".accdb" extension — it is created in the Access 2007-2010 file format and is not readable by earlier versions of Access.

In some cases, you may prefer to create files in an earlier Access format. In Microsoft Access 2010, you have the option of creating files in either the Access 2000 format or the Access 2002-2003 format (both with the extension ".mdb"). Then, when you create a new database file, the resulting file is created in the earlier Access format and can be shared with others who use that version of Access. This can be helpful if you have upgraded to Access 2010 but you share files with others who have not.

 Note    You cannot convert a database that uses an earlier format to a web database.

To change the default file format

  1. Click the File tab.
  2. Under Help, click Options.
  3. In the Access Options dialog box, click Popular.
  4. Under Creating databases, in the Default file format box, select the file format you want as the default.
  5. Click OK.
  6. Click the Office Button, and then point to New.
  7. To create a new file, type the file name you want (be sure to leave the extension as is) and click Create. If you don't want to create a file at this time, click Cancel.

Convert a database from one format to another

If you have an existing database that you want to convert to a different format, you can choose a format under the Save Database As command. This command preserves the database in its original format and creates a copy of the database in the format you specify. You can then use the copy of the database with the version of Access that you want.

 Note   If the original database is in Access 2007-2010 format and contains complex data, offline data, or attachments that were created in Access 2007-2010 format, you cannot save the copy in an earlier format, such as Access 2000 or Access 2002-2003.

  1. If the database is not open already, open the database you want to convert.
  2. Click the File tab, and then click Save Database As.

     Note    If any database objects are open when you try to save it in a different format, Access must close the objects prior to creating the copy. Click Yes to have Access close the objects (Access prompts you to save any changes, if needed), or click No to cancel the entire process.

  3. In the File name box in the Save As dialog box, type a file name for the copy of the database.
  4. Click Save Button image. Access creates the copy and then opens it.
 
 
Applies to:
Access 2010