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


  • Microsoft Office Access 2007


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.


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.


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