Creating forms for Users not Administrators

[missionAccess]

First time using access...about 3 days into my learning. I am using access for 3-5 users who are not knowledgeable about access. I only need them to input data through the forms or retrieve data from the queries. How do I accomplish this without then interacting with the Access program itself?

[John_G]

There are several ways to do this.

One way is to have Access open the main form when the application is started, and have that form close MS Access when the form closes.

If you make all the forms opup and modal, this keeps users out of the ribbon (they can see it, but not use it). However, that approach makes using select queries difficult, because they won't open on top of modal forms.

A line or two of code can hide the ribbon completely.

You can also disable the special keys (Ctrl_G, F11, etc) with File - Options - Current Database, and clear the Use Access Special Keys checkbox.

With a little bit of VBA code you can also disable the Shift key when opening the application.

Which of these options you use depends how much protection you need.

John