[ Team LiB ] Previous Section Next Section

Converting Access Databases

In a multi-user environment, you may need to support users that run different versions of Access, or you may need to upgrade older databases to Access 2003. When you open a database from a previous Access version, Access 2003 prompts you to either upgrade the database file or open it without upgrading. You can also convert a database to the previous Access format.

Set Default Access File Format

graphics/1_icon.jpg

Click the Tools menu, and then click Options.

graphics/2_icon.jpg

Click the Advanced tab.

graphics/3_icon.jpg

Click the Default File Format list arrow, and then click a format.

graphics/4_icon.jpg

Click OK.

graphics/12inf19.jpg

Convert a Database to Another Version of Access

graphics/1_icon.jpg

Click the Tools menu, point to Database Utilities, and then point to Convert Database.

graphics/2_icon.jpg

Click the command with the version in which you want to convert the database.

graphics/3_icon.jpg

Enter the name for the converted database.

graphics/4_icon.jpg

If necessary, click the Save In list arrow, and then select the drive and folder where you want to save the database.

graphics/5_icon.jpg

Click Save.

graphics/12inf20.jpg

    [ Team LiB ] Previous Section Next Section