Office Button Manipulation

[mikemaki]

I recently was asked to find out what it would take to migrate our applications from Access 2002-2003 to Access 2007. We use a fairly sophisticated custom built secuity wrapper. I think once we get used to ribbon customization, it will be quite useful. But one thing I am concerned about is the Access Options button on the Office button. I have read that the Windows button can't be disabled. Does anyone know if there is a way to manipulate the Access Options button? We do not want users changing database properties.

 

[boblarson]

If you uncheck the Allow Full Menus checkbox in the Access Options > Current Database, then you won't get anything but basically a Close Button and Exit Button inside the Office Pearl.

 

[mikemaki]

Thanks, Bob, that is helpful info. I've only been playing with 2007 for about a week now. It's like a new toy.

But in my world, we have 3 environments. One for development that has a Modal form that has a text box. The correct word entered in the text box will close the form and expose the database in design view.

Then we copy the database to a Test folder. We click a button and the database programatically goes into Normal mode. Now when it is opened, a pop up form opens asking for a userid and password. All the menus and toolbars are changed to lock down the design view. Then it is copied to Live. The live environment goes one step further and even I can't get into design view.

I'm looking for some way we can programatically change the UI so we can lock a copy down from the user changing the database properties but we can change it back in case the developer needs to get in there. Is there any Command or XML code that will check and uncheck that box?