Convert an Access 2000 database to Access 97

Convert an Access 2000 database to Access 97

  1. Open the Microsoft Access database that you want to convert. If it is a multiuser database that is located on a server or in a shared folder, make sure that no one else has it open.

    Important   If you have protected the Microsoft Visual Basic for Applications (VBA) code, you must supply the password before you convert the Access database. To supply the password, start Microsoft Visual Basic by opening a module; then click databasename Properties on the Tools menu and enter the password in the databasename Password dialog box..

    If you are converting a secured Access database, you must have Open/Run and Open Exclusive permissions for the database itself, and Read Design permissions for all objects in the database. To secure the converted database, you must open it in Microsoft Access 97 and apply user-level security.

  2. On the Tools menu, point to Database Utilities, click Convert Database, and then click To Prior Access Database Version.

  3. In the Convert Database Into dialog box, type the name of the new previous-version database that you want to create in the File name box, and then click Save.

Note   If your Access 2000 database contains code, you may need to fix missing references after you have converted it to Microsoft Access 97. Also, if your Access database uses add-ins or library databases that were created in Access 2000, you must convert them back to Access 97 as well.

Learn more about converting an Access 2000 database to Access 97.