When you create a new, blank database in Microsoft Office Access 2007, you are prompted to provide a name for the database file. By default, the file is given the ".accdb" extension — it is created in the Office Access 2007 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 Office Access 2007, 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 Office Access 2007 but you share files with others who have not.
To change the default file format
- Click the Microsoft Office Button , and then click Access Options.
- In the Access Options dialog box, click Popular.
- Under Creating databases, in the Default file format box, select the file format you want as the default.
- Click OK.
- Click the Microsoft Office Button , and then click New.
If you have enabled the viewing of file name extensions in Windows Explorer, you should see the appropriate file name extension in the File Name box in the Blank Database pane (".mdb" for Access 2000 and Access 2002-2003, ".accdb" for Office Access 2007). If you have not enabled the viewing of file name extensions in Windows Explorer, you can ensure that the correct file format is being created by clicking Browse next to the File Name box and, in the File New Database dialog box, observing the file format in the Save as type box.
- 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 Office Access 2007 format and it contains complex data, offline data, or attachments that were created in Office Access 2007 format, you cannot save the copy in an earlier format, such as Access 2000 or Access 2002-2003.
- If the database is not open already, open the database you want to convert.
- Click the Microsoft Office Button , point to Save As, and then, under Save the database in another format, click the file format to which you want to convert.
For example, if the original database is in Office Access 2007 format, you can click Current Format to save the copy in the same format as the original, or choose one of the earlier formats.
- If any database objects are open when you use one of the Save Database As Other Format commands, Access prompts you to 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.
- In the File name box in the Convert Database Into dialog box, type a file name for the copy of the database.
- Click Save . Access creates the copy and then opens it.