Show only forms and prevent users from opening design view

[justair07]

Hello,

I'm trying to protect the frontend of my database from unwanted changes. I was hoping someone can help me disable the navigation pane, ribbon, and only display my navigation form. My navigation form has 10 buttons that open forms for data entry. I only want the users to be able to open forms and add data. I don't want them to be able to go to the navagation pane or anything other than the forms. I'm clueless on how to accomplish this, any help is greatly appreciated.

Thank you,

[justair07]

Ok, so I discovered how to create MDE file but now every time the database is opened, this pops-up:

I can disable it on my computer manually but when I send it out to 40 people I would like for it to not pop up for them as well.
Any ideas?

[June7]

I don't think you can, at least not for the first time. They have to decide whether or not to 'trust' the db. http://office.microsoft.com/en-us/ac...010342008.aspx