How can I remove the menus and toolbars in Access?

[MilesNepo]

I'd like to remove the Programmer's Menus and Toolbars in MS Access '97 so that the Users will not be able to edit the Form, Report, etc. But if it's the Admin then he should be able to open the Form in Design Mode and be able to see the code. Is this possible?

[Andrew_Fryer]

In the tools menu there is an option entitled 'Startup'. The dialog here allows you to remove the toolbars and menus.

[MilesNepo]

Thanks, but I've tried this and it works I removed the menus and toolbars and set it to default. But if the Admin wants to access the Database and Open a Table, I'd like the Admin able to Browse the Table, Forms, or Reports in Design Mode.

[Andrew_Fryer]

Have you tried setting the permissions using the Security option in the tools menu. I am not completely familiar with this, but I think it allows you to set levels of permissions based on the user who is logged on. That should do it I think.

[fedoroff]

You need to create your own custom toolbar and menubar. Assign them to the form using "Toolbar" and "Menubar" properties of the form