Microsoft KB Archive/833877

= BUG: Access quits unexpectedly when you open a digitally-signed database with grouped controls in Access 2003 =

Article ID: 833877

Article Last Modified on 8/14/2007

-

APPLIES TO


 * Microsoft Office Access 2003

-



This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

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



SYMPTOMS
When you open a digitally-signed database or a database project in Microsoft Office Access 2003, and the database or the database project contains forms that have grouped controls or reports that have grouped controls, Access 2003 may quit unexpectedly. You may receive the following error message:

Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.

You may also receive the following error message:

The document ' ' caused a serious error the last time it was opened. Would you like to continue opening it?



Service pack information
To resolve this problem, obtain the latest service pack for Microsoft Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

842532 Description of Office 2003 Service Pack 1



WORKAROUND
To work around the problem, you must ungroup the controls in the digitally-signed database. However, to open the problem database and to ungroup the controls, you must temporarily set the Macro Security Level to Low. To do this, follow these steps:
 * 1) Start Access 2003.
 * 2) On the Tools menu, click Macro, and then click Security.
 * 3) In the Security dialog box, click Low (not recommended) on the Security Level tab.
 * 4) Click OK.
 * 5) Click Yes, and then click OK.
 * 6) Open the problem digitally-signed database.
 * 7) Open the forms or the reports that contain grouped controls. Ungroup the controls.
 * 8) Save your changes.
 * 9) On the Tools menu, click Macro, and then click Security.
 * 10) In the Security dialog box, click either Medium or High on the Security Level tab to reset your original security level.
 * 11) Click OK.
 * 12) Click Yes, and then click OK.
 * 13) Open the problem database that is digitally signed.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was first corrected in Office 2003 Service Pack 1.



Steps to reproduce the problem
 Start Access 2003. On the Tools menu, click Macro, and then click Security. In the Security dialog box, click either Medium or High on the Security Level tab.

Note The default security level is Medium. Open the Northwind.mdb sample database. In the Database window, click Forms under the Objects section.</li> In the right pane, double-click Create form in Design view.</li> Add two Text Box controls to the form.</li> Select the two Text Box controls.</li> On the Format menu, click Group.</li> Save the form. Name the form Form1.</li> Close Form1.</li> On the Tools menu, click Macro, and then click Visual Basic Editor.</li> Add a digital signature to the database. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> On the Tools menu, click Digital Signature.</li> In the Digital Signature dialog box, click Choose.</li> In the Select Certificate dialog box, select one of the available certificates, and then click OK.

Note If the Select Certificate dialog box does not contain any certificates, you can create your own certificate and then complete the previous steps.</li> In the Digital Signature dialog box, click OK.</li></ol> </li> Close the Visual Basic Editor, and then close Access.</li> Start Access 2003.</li> Open the Northwind.mdb sample database.

When you try to open the Northwind.mdb sample database, you may receive the error message that is mentioned in the &quot;Symptoms&quot; section.</li></ol>

<div class="references_section">