Converting

Unlike earlier versions of Access, Access 2002 defaults to the Access 2000 file format, supposedly for backward-compatibility. To change the default format for the open database, select Tools , Database Utilities , Convert Database ; then select the appropriate file format from the last submenu (see Figure 2.10). Access prompts you to give the converted database a new nameenter one and click Save . Keep in mind that anytime you convert a database to an earlier version, Access might have to remove database features that aren't supported in that version.

Figure 2.10. Select a file format for the database.

You can change the format default permanently. Select Tools , Options . Next, click the Advanced tab and select Access 2002 from the Default File Format option shown in Figure 2.11. (You must have an open database to alter settings in the Options dialog box.) If you'll never need to share your databases with someone who's using an older version of Access, you should make this change. That's the easiest way to ensure that you can use Access 2002 to its fullest potential.

Figure 2.11. Permanently modify Access's file format.

Opening Databases from Earlier Versions

When you open a database that was saved in an earlier format, Access displays the Convert/Open Database dialog box shown in Figure 2.12. The default option is Convert Database, which converts the earlier format to the default format (see the previous section).

Figure 2.12. Choose to convert or open without converting.

On the other hand, the Open Database option enables you to view the database without changing the file's format. While in this mode, you can modify data, but you can't make design changes. For example, you can't change the color of a form or the caption on a report in this mode.

Caution

Be especially careful when you choose to convert an earlier file version when opening that file in Access. After you convert the file, you won't be able to open it in the original version. In other words, if you convert an Access 97 or Access 2000 file to Access 2002, you will no longer be able to open that file in Access 97 or Access 2000, respectively.