ACC2000: 'No Object in this Control' Converting Access 2000 Database to Access 97

ID: Q202312


The information in this article applies to:

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

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


SYMPTOMS

After converting a Microsoft Access 2000 database to Microsoft Access 97, you receive the following error message when you open a form or report in the new Microsoft Access 97 database:

There is no object in this control.


CAUSE

The form or report contains one or more ActiveX controls. The error occurs because Microsoft Access 2000 uses the IPersistStream interface for inserting and storing ActiveX controls while Microsoft Access 97 uses the IPersistStorage interface.


RESOLUTION

In order for Microsoft Access 97 to recognize ActiveX controls inserted by Microsoft Access 2000, the ActiveX control must be inserted using the IPersistStorage interface. Microsoft Access 2000 uses the IPersistStorage interface if you create the ActiveX control by pasting it into the form or report. To resolve the problem, follow these steps:

  1. Start Microsoft Access 2000 and open your Microsoft Access 2000 database.


  2. Individually open each form or report that contains an ActiveX control.


  3. Individually select each ActiveX control on the form or report.


  4. On the Edit menu, click Cut.


  5. On the Edit menu, click Paste.


  6. After pasting all ActiveX controls, close and save each form and report.


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


  8. Type a file name for the new Access 97 database, and then click Save.


  9. Start Microsoft Access 97.


  10. Open the Microsoft Access 97 database that you created in step 8.


  11. Open a form or report that contains an ActiveX control.

    Note that you can open the form or report.



STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Problem

CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.

  1. Start Microsoft Access 2000.


  2. Open the sample database Northwind.mdb.


  3. Open a new blank form in Design view.


  4. On the Insert menu, click ActiveX control.


  5. Click the Calendar Control 9.0, and then click OK.


  6. Close and save the form.


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


  8. Type a file name for the new Access 97 database, and then click Save.


  9. Start Microsoft Access 97.


  10. Open the Microsoft Access 97 database that you created in step 8.


  11. Open the form that you saved in step 6.


  12. Note that you receive the message:
    There is no object in this control.

Additional query words: prb pra


Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: May 13, 1999