Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an Access 2007 database (.accdb) and I want to lock down settings being changed to it, specifically under menu->Access Options->Current Database->"Display Form" etc.

I understand you can save it as a .accde which locks down a number of options, but this does not seem to accomplish what I want.

How can I lock down "Access Options->Current Database"?

I'd need to lock down the database per the file, not per user.

share|improve this question
    
Have you considered removing that option from the menu completely for that particular database? I know it's possible in Access 97, and Microsoft has a tendency to keep features. –  user3463 Apr 26 '12 at 22:27
    
That would be great. How can that be done? –  JBurace Apr 27 '12 at 16:22
    
Unfortunately I'm unfamiliar with Access past 97. Check GoogleBing for "hiding menu options" or similar. –  user3463 Apr 27 '12 at 18:12
    
@RandolphWest Is this suppose to be a client setting, or a file setting? I found something like DoCmd.ShowToolbar "Ribbon", acToolbarNo but that's all it said, no idea where to put that. –  JBurace Apr 27 '12 at 20:34
    
It's a file setting. The idea is that you can modify the UI on a per-database level. –  user3463 Apr 27 '12 at 20:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.