Tuesday, July 29, 2014

How To Converting Access Databases in Access 2003

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