How to suppress the Convert/Open Database dialog box when you open an Access 97 database

This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

When you open a Microsoft Access 97 database by using Access 2003, the Convert/Open Database dialog box appears. You can suppress the display of the Convert/Open Database dialog box if you want to. To do this, you must add the NoConvertDialog registry entry to the Access Settings subkey in the registry. This setting does not prevent conversion. This setting only prevents the initial Convert/Open Database dialog box from appearing when the database is opened.

Note Access 2003 does not display the Convert/Open Database dialog box when you open a database that is in a Microsoft Access 2000 file format.

The NoConvertDialog subkey controls whether the Convert/Open Database dialog box appears. To add the NoConvertDialog subkey, follow these steps:

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

1. On the taskbar, click Start, and then click Run.
2. In the Run dialog box, type regedit, and then click OK.
3. In Registry Editor window, locate the following registry key:
   
   HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Access\Settings\
4. On the Edit menu, point to New, and then click DWORD Value. Name the new DWORD NoConvertDialog.
5. In the right pane of Registry Editor, double-click the NoConvertDialog DWORD.
6. In the Edit DWORD Value dialog box, click Decimal that is under Base.
7. In the Value Data box, type 1, and then click OK.
   
   Note When you set the value to 0, the Convert/Open Database dialog box appears.
8. Close Registry Editor.
9. Start Microsoft Office Access 2003.
10. On the File menu, click Open.
11. Locate the Access 97 database, and then open it.
    
    Notice that the database opens without prompting you to open it or to convert it. The database remains in Access 97 file format.

To convert the database, follow these steps:

1. On the Tools menu, point to Database Utilities, and then point to Convert Database.
2. Click one of the following choices:
   • To Access 2002 - 2003 File Format
   • To Access 2000 File Format

The registry subkey can be forced ON or forced OFF by a Group Policy setting. When a matching Group Policy setting is in place, the registry setting that was mentioned previously is ignored.

You can force the Group Policy ON or OFF by using the Group Policy Console. To do so, follow these steps:

1. Install Microsoft Office 2003 Resource Kit.
2. On the taskbar, click Start, and then click Run.
3. In the Run dialog box, type gpedit.msc in the Open box, and then click OK.
4. In the Group Policy console, expand Computer Configuration under Local Computer Policy.
5. Select Administrative Templates.
6. On the Action menu, click Add/Remove Templates.
7. In the Add/Remove Templates dialog box, click Add.
8. In the Policy Templates dialog box, locate ACCESS11.ADM on your computer, and then click Open.
9. In the Add/Remove Templates dialog box, click Close.
10. In the Group Policy console, expand User Configuration that is under Local Computer Policy.
11. Expand Administrative Templates.
12. Expand Microsoft Office Access 2003, and then click Miscellaneous.
13. In the right pane, double-click Do not prompt to convert older databases.
14. In the Do not prompt to convert older databases Properties dialog box, click Enabled on the Policy tab. Click to select the Check to enforce setting on; uncheck to enforce setting off check box.
15. Click Apply, and then click OK.

Note When you use the Group Policy Console, the changes are made to the Policy setting through the following subkey in the registry:

HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Access\Settings

Note The NoConvertDialog setting is intended to suppress only the Convert/Open Database dialog box. After a registry key is added, you continue to receive the following error message: Before Access 2002 Service Pack 3 and Access 2003 Service Pack 1, the previous error message was unintentionally suppressed. To prevent the previous message from appearing, you can add a Startup form to the Access 97 database.

For more information about multiple file formats in Access 2003, click Microsoft Access Help on the Help menu, type about using an Access file with multiple versions of Access in the Search for box in the Assistance pane, and then click Start searching to view the topic.

For more information on Microsoft Office 2003 Resource Kit, visit the following Microsoft website:
http://www.microsoft.com/office/ork/2003/default.htm (http://www.microsoft.com/office/ork/2003/default.htm)