Which file format should I use in Access 2007?
Microsoft Office Access 2007 introduces a new file format that uses the .accdb file extension. In addition, Office Access 2007 continues to provide some support for the file format used in earlier versions of Access. This article explains why you should use the new file format whenever possible, and why you might need to use the earlier version file format in some instances. You will also learn explicitly how to convert a database to the new file format.
In this article
The new file format (.accdb)
Office Access 2007 employs a new file format that supports a number of product enhancements. When you create a new database in Access 2007, the database uses the new file format by default and is given the .accdb file extension.
You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. However, the new file format cannot be opened or linked to with earlier versions of Access, it does not support replication, and it does not support user-level security. If you need to use the database with earlier versions of Access, or if you need to use replication or user-level security, you must use an earlier version file format.
The new features supported in the .accdb file format include:
Suppose you need to assign a task to one of your employees but decide that you need to assign it to more than one person. In Office Access 2007 you can create a multivalued field where the employees' names can be selected from or entered in a box.
When you click the box, check boxes that are selected indicate your choices. The selected employees are stored in the multivalued field and are separated by commas (by default) when displayed.
The idea behind multivalued fields is to make it easy to select and store more than one choice, without having to create a more advanced database design. Multivalued fields are also important for integration with Windows SharePoint Services 3.0, because SharePoint lists also support multivalued fields.
Multivalued fields are only supported by using the new .accdb file format.
Attachment data type
The new Attachment data type lets you easily store all types of documents and binary files in your database without excessive growth in the physical size of the database. Attachments are automatically compressed, when appropriate, to maximize space usage. You can attach a Microsoft Office Word 2007 document to a record, or save a series of digital pictures. You can even keep multiple attachments attached to a single record.
The attachment data type is only supported by using the new .accdb file format.
Improved integration with Windows SharePoint Services and Microsoft Office Outlook 2007
In the past, Access files in the .mdb format were blocked by Windows SharePoint Services or Outlook due to the fact that unsafe code can be included within an Access database. Office Access 2007 allows code to be either verified as safe or disabled. This makes it possible to integrate Access databases more fully with Windows SharePoint Services or Outlook.
This ability to better integrate Access databases with Windows SharePoint Services or Outlook is only supported by using the new .accdb file format.
Take a SharePoint list offline with Access
You can take your SharePoint lists offline with one click by using Office Access 2007. Work on your data in Access and then synchronize your changes, or reconnect with the SharePoint site at a later time.
The ability to take a SharePoint list offline with Access is only supported by using the new .accdb file format.
Memo field history tracking
Memo fields are useful for storing large amounts of information. Starting with Office Access 2007, you can set a property (AppendOnly) that forces Access to retain a history of all changes to a Memo field. You can then view a history of those changes. This feature also supports the versioning feature in Windows SharePoint Services 3.0 so that you can use Access to track changes in multiple lines of a text field that is stored in a SharePoint list (provided that the field has the Append Changes to Existing Text option set to Yes).
History tracking for Memo fields is supported only by using the new .accdb file format.
You can choose to set a database password and encrypt the contents of your database. When you do so using Office Access 2007 and a file that uses the new file format, Access uses the Windows Crypto API to encrypt the data.
Improved encryption is supported only by using the new .accdb file format.
The earlier version file format (.mdb)
Versions of Access earlier than Office Access 2007 support file formats that use the .mdb file extension. In Office Access 2007 you can still open .mdb files. If the file is stored in the Access 2002-2003 or Access 2000 file format, you can open it and use it in Office Access 2007 as you normally would. However, you cannot take advantage of the new features that require the .accdb file format.
If the file is stored in the Access 95 or Access 97 file format, when you first open it in Office Access 2007, Access offers to upgrade the database to the file format currently set as the default file format (usually the .accdb file format, unless you or an administrator has changed the setting). If you do not plan to use the database with versions of Access earlier than Access 2007, and you will not be sharing the database with other users who use versions of Access earlier than Access 2007, and you do not use replication or user-level security, you should upgrade the database file to the new .accdb format. After you upgrade the database to the .accdb file format, you can no longer open the database by using a version of Access earlier than Access 2007.
If the file is stored in Access 95 or Access 97 format and you choose not to upgrade to the .accdb format, you cannot make design changes. You can view objects and make changes to your data through Office Access 2007, but you cannot make design changes.
Converting to the new file format
To explicitly convert an Access database to the new .accdb file format, you must first open the database and then save it in the .accdb file format. The following procedure is for files created in Access 97, Access 2000, Access 2002 or Access 2003. For information on importing and converting Access 2.0 or Access 95 database files, see the links in the See Also section.
First, open your database:
Click the Microsoft Office Button , and then click Open.
In the Open dialog box, select and open the database that you want to convert.
Now, convert your database:
Click the Microsoft Office Button , and then point to Save As.
Under Save the database in another format, click Access 2007 Database.
In the Save As dialog box, in the File name box, enter a file name or use the file name supplied.
A copy of the database is created in the .accdb file format.