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



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net