Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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

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

↑ Back to the top


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 '<database name>' caused a serious error the last time it was opened. Would you like to continue opening it?

↑ Back to the top


Resolution

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

↑ Back to the top


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.

↑ Back to the top


Status

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

↑ Back to the top


More information

Steps to reproduce the problem

  1. Start Access 2003.
  2. On the Tools menu, click Macro, and then click Security.
  3. In the Security dialog box, click either Medium or High on the Security Level tab.

    Note The default security level is Medium.
  4. Open the Northwind.mdb sample database.
  5. In the Database window, click Forms under the Objects section.
  6. In the right pane, double-click Create form in Design view.
  7. Add two Text Box controls to the form.
  8. Select the two Text Box controls.
  9. On the Format menu, click Group.
  10. Save the form. Name the form Form1.
  11. Close Form1.
  12. On the Tools menu, click Macro, and then click Visual Basic Editor.
  13. Add a digital signature to the database. To do this, follow these steps:
    1. On the Tools menu, click Digital Signature.
    2. In the Digital Signature dialog box, click Choose.
    3. 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.
    4. In the Digital Signature dialog box, click OK.
  14. Close the Visual Basic Editor, and then close Access.
  15. Start Access 2003.
  16. 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 "Symptoms" section.

↑ Back to the top


References

For more information about the issues that are fixed in Access 2003 by Office 2003 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
872834� Issues that are fixed in Access 2003 by Office 2003 Service Pack 1
For more information about grouping controls and ungrouping controls, click Microsoft Office Access Help on the Help menu, type Group controls or ungroup controls in the Search for box in the Assistance pane, and then click Start searching to view the topic.

For more information about how to create your own digital certificate, click Microsoft Office Access Help on the Help menu, type Create your own digital certificate in the Search for box in the Assistance pane, and then click Start searching to view the topic.

↑ Back to the top


Keywords: KB833877, kbmacro, kbsecurity, kberrmsg, kbctrl, kbbug, kbopenfile

↑ Back to the top

Article Info
Article ID : 833877
Revision : 3
Created on : 8/14/2007
Published on : 8/14/2007
Exists online : False
Views : 343