Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Browse other questions tagged .