Migrating to Access 2007

Microsoft Office Access 2007 provides a powerful set of tools that help you to quickly start tracking, reporting, and sharing information in a manageable environment. With its new, interactive design capabilities, prebuilt library of tracking application templates, and the ability to work with many data sources, including Microsoft SQL Server, Office Access 2007 allows you to rapidly create attractive and functional tracking applications without requiring deep database knowledge. You can quickly create and adapt applications and reports to fit your changing business needs, and with its enhanced deep integration with Windows SharePoint Services 3.0, Office Access 2007 helps you share, manage, audit, and back up information.

For more information about what is new and improved in Office Access 2007, see the article What's new in Microsoft Office Access 2007.

In this article


Migrating from Microsoft Office Access 2003, Access 2002, or Access 2000

If you are using Microsoft Office Access 2003, Access 2002, or Access 2000, migrating to Access 2007 is easy. Access 2007 supports the Access 2002 - 2003 and Access 2000 .mdb file formats so, in most cases, you only need to install Access 2007 and open your Access 2002 - 2003 or Access 2000 databases — and you can then use those as you would use an Access 2007 database. However, Access 2007 includes many new and useful features (such as attachments and multivalued fields) that require the new .accdb file format, so you should use the new file format whenever possible. If you continue to use the .mdb file format, you cannot take advantage of those new features.

For more information about the features that are available only in the .mdb file format, and the features that are available only in the .accdb file format, see the article Which file format should I use in Access 2007?

Some features of previous versions of Access are no longer supported, such as user-level security and replication. For more information about these features, see the article Migration considerations for Access 2007.

Top of Page Top of Page

Migrating from Access 97

When you open an Access 97 database in Access 2007, the Database Enhancement dialog box appears. To convert the database to the Access 2007 file format, click Yes. Access then creates a copy of the database in the .accdb format.

 Note   You cannot use the .accdb file format in earlier versions of Access.

If you click No in the Database Enhancement dialog box (that is, choose not to convert the database), you can still open your .mdb file format database. You can view objects and modify records by using Access 2007, but any design changes that you make will not be saved.

Top of Page Top of Page

Migrating from Access 95

If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into an Office Access 2007 format (.accdb) database. You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code.

To import forms and reports that contain VBA code (and also modules), first convert your Access 95 format database to the Access 2002 - 2003 file or Access 2000 format by using Microsoft Office Access 2003, Access 2002, or 2000, and then use Access 2007 to convert that file to the Access 2007 file format. For more information, see the article Import an Access 95 database into an Access 2007 file.

Top of Page Top of Page

Migrating from Access 2.0

If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into an Office Access 2007 format (.accdb) database.

To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, then you open the database in Access 2007, and then you convert the database into the Access 2007 database format. For more information, see the article Import an Access 2.0 database into an Access 2007 file.

Top of Page Top of Page

 
 
Applies to:
Access 2007