ACC: Installing Access 95 or 97 Breaks 2.0 Calendar Control

• Microsoft Access versions 2.0, 7.0, 97
• Microsoft Access Developer's Toolkit version 2.0

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

If you install Microsoft Access 7.0 or 97 on a computer that contains Microsoft Access 2.0 and Microsoft Access Developer's Toolkit version 2.0, you may receive the following error message when you try to add a Calendar Control object to a form or report:

   There is a problem with the registration database.

CAUSE

When you install Microsoft Access 7.0 or 97, the Setup program creates the following key under HKEY_CLASSES_ROOT in your Windows Registry:

   CLSID\{399A11C0-CFAC-101A-B8A0-00608CB87234}\AutoConvertTo

RESOLUTION

If you want to continue to use the Calendar control in version 2.0, you can edit the Windows Registry and rename the AutoConvertTo key. The following steps show you how.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Microsoft Windows 95 or Microsoft Windows NT. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

1. Start the Registry Editor program, Regedit.exe.

2. Locate the following key under HKEY_CLASSES_ROOT:

         CLSID\{399A11C0-CFAC-101A-B8A0-00608CB87234}\AutoConvertTo
   

3. Using the right mouse button, click the AutoConvertTo key, and then click Rename on the shortcut menu.

4. Rename the key to AutoConvertToX.

5. Start Microsoft Access 2.0 and add the Calendar control to a form. Note that the error no longer occurs.

MORE INFORMATION

This problem only occurs when you have Microsoft Access 2.0 and Microsoft Access Developer's Toolkit version 2.0 on your computer, and then you set up Microsoft Access 7.0 or 97 in a separate folder on the same computer.

If you follow the steps in the "Resolution" section to change the Windows Registry key, you will encounter error messages if you try to convert a version 2.0 database with a Calendar control in Microsoft Access 7.0 or 97. You can follow the steps again to rename the AutoConvertToX Registry key back to AutoConvertTo before you convert your database.

If the Registry key is missing when you convert your version 2.0 database, you may receive the following error messages.

Using Microsoft Access 7.0

   The following warning occurs during conversion of your Microsoft Access
   2.0 database:

      One or more functions or reports contains a 16-bit OLE custom control
      with no 32-bit equivalent. These controls will not function properly
      under Microsoft Windows 95 or Microsoft Windows NT.

   After the database is converted, you receive the following error when
   you open an object that contains the Calendar control:

      The object application isn't registered.

Using Microsoft Access 97

   The Microsoft Access 2.0 database converts without any warnings, but
   you receive the following error message when you open an object that
   contains the Calendar control:

      There is no object in this control.

Steps to Reproduce Behavior

1. If it isn't already installed, run Setup to install Microsoft Access 2.0 on your computer.

2. If it isn't already installed, run Setup to install Microsoft Access Developer's Toolkit version 2.0.

3. Run Setup to install Microsoft Access 7.0 or 97 on your computer. Do not remove version 2.0.

4. Start Microsoft Access 2.0 and open the sample database NWIND.MDB.

5. Create a new form not based on any table or query in Design view.

6. On the Edit menu, click Insert Object.

7. In the Insert Object dialog box, click Insert Control.

8. Click Calendar Control in the Control Type box, and then click OK. Note that you receive the error message:

         There is a problem with the registration database.
   

REFERENCES

For more information about using the Calendar control in Microsoft Access 2.0, search the OLE Calendar Control Help file, Msacal20.hlp.