Share this Page URL

Chapter 18. Maintaining an Access Databa... > Converting an Access Database - Pg. 632

Maintaining an Access Database 632 You can convert a database created in the Access 2000 file format or the Access 2002-2003 file format to the Access 97 file format (if a group of users have not upgraded to a later version). Users who work with the file in Access 97 can change data, but they won't be able to modify the database. You can also convert a database created in the Access 2002-2003 file format to a file format com- patible with an earlier version of Access (either Access 97 or Access 2000). If you convert an Access 2000 database to the Access 2002-2003 file format, you can't open the file in Access 2000. Changing the default file format If you want to change the default file format in Access 2003, click Options on the Tools menu, and then click the Advanced tab. Select the format you want to use from the Default File Format list. In the following steps, we'll describe how to convert an Access database as well as the options you have when you open a database saved in the Access 97 file format in Access 2003. Convert an Access database 1. 2. Start Access if the program isn't open. On the toolbar, click the Open button, and then open the Chap18 folder at the location where you copied the sample files for this book. Select the file named HelloWorld18_97.mdb, and then click Open. You'll see the dialog box shown here: