You are here:   10-1

10-1

Using RibbonCreator with secured MDB files:

(Tipp by: B. Beacham)  

 

Adding a ribbon to a secured file:

  1. Open target MDB file with a developer account, and do this:
    • If VBA Project is locked for viewing, unlock it.
    • If the Start-Up Bypass key (normally the 'Shift' key) has been disabled, re-enable it.
  2. In Ribbon Creator application, when opening the database to install the new ribbon, use your normal developer user account, and hold the "Shift" key after entering password to prevent auto-run events from occurring.
  3. After ribbon is installed, re-open the MDB file as developer and reverse the steps you took in step 1.


Note:
I have used the Workgroup Administrator to join the correct workgroup security file by default. If Access is set up to use default (no) security, you might need to take this step. (In the VBA Immediate window, enter: RunCommand acCmdWorkgroupAdministrator

Loading a custom ribbon from a secured file into RibbonCreator:

  1. Open target MDB file with a developer account, and do this:
    • Give 'Admin' user account Open/Run permissions for Current Database (just the database object, not every object in the database).
    • Give 'Admin' user account Read Data permissions for USysRibbons table
  2. Close MDB file and use Ribbon Creator to grab the ribbon.
  3. When you are through, re-open the MDB file and remove the Current Database permissions you set for the 'Admin' user in step 1.

 

Zurück

 

Last Updates:

22.09.2015
IDBE RibbonCreator 2016 (x86 and x64) for Office 2013 and Office 2016 - first release. ...


07.04.2013
Revised versions for RibbonCreator (Version: 1.1040) Revised versions for RibbonCreator 2013 (Version: 1.1002) Revised versions for R...

16.03.2013
IDBE RibbonCreator 2013 first release. ...

19.10.2011
Revised versions for IDBE RibbonCreator (Version 1.1039) Site Release notes updated. ...

 

Last update:
January 22, 2017, 17:47