Microsoft KB Archive/926533

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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