Microsoft KB Archive/202312

= ACC2000: "There Is No Object in This Control" Error Converting Access 2000 Database to Access 97 =

Article ID: 202312

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q202312



For a Microsoft Access 2002 version of this article, see 286345.

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 that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Problem
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

 Start Microsoft Access 2000. Open the sample database Northwind.mdb. Open a new blank form in Design view. On the Insert menu, click ActiveX control. Click the Calendar Control 9.0, and then click OK.</li> Close and save the form.</li> On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Prior Access Database Version.</li> Type a file name for the new Access 97 database, and then click Save.</li> Start Microsoft Access 97.</li> Open the Microsoft Access 97 database that you created in step 8.</li> Open the form that you saved in step 6. Note that you receive the message:

There is no object in this control.

</li></ol>

Additional query words: prb pra

Keywords: kbbug kbpending KB202312

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.