Microsoft KB Archive/926533

From BetaArchive Wiki
Knowledge Base


You cannot open the front-end database when the back-end database is encrypted by using a password in Access 2007

Article ID: 926533

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Access 2007



SYMPTOMS

When you try to open a front-end database in Microsoft Office Access 2007 after you encrypt the back-end database by using a password, the front-end database does not open.

CAUSE

This issue occurs if the following conditions are true:

  • The database contains a custom Ribbon.
  • You split the database, and then encrypt the back-end with a password.

In this situation, when you open the front-end database, Access 2007 tries to use the USysRibbons table to obtain the custom Ribbon information. However, because the USysRibbons table resides in the encrypted back-end database, the front-end database cannot be successfully opened.

RESOLUTION

To resolve this issue, create the custom Ribbon after you split the Access 2007 database.


Additional query words: AC2007 ACC2007 Access2007

Keywords: kbtshoot kbprb kbexpertiseinter KB926533