limiting access question

  • Thread starter Thread starter Melanie
  • Start date Start date
M

Melanie

Hello,
I have created a database, and now I am trying to
understand how to put security settings in it for users
and myself. Basically, the only thing that anyone other
than myself should be able to do is see certain forms and
a single report, and to do data entry on some forms.
My question is, the main data entry form they will be
working with has 2 subforms on it. They will be entering
data in these subform sections also. If I set security to
data entry on the main form, and hide the actual subform
from them (I don't want them going in there), what will
happen in the main data entry form? Will they be able to
do data entry in the subform section of the main form?
Sorry if this sounds confusing, and thanks for any help.
Melanie
 
Melanie said:
Hello,
I have created a database, and now I am trying to
understand how to put security settings in it for users
and myself. Basically, the only thing that anyone other
than myself should be able to do is see certain forms and
a single report, and to do data entry on some forms.
My question is, the main data entry form they will be
working with has 2 subforms on it. They will be entering
data in these subform sections also. If I set security to
data entry on the main form, and hide the actual subform
from them (I don't want them going in there)
Click to expand...

I don't understand. You say they will be entering data in the subforms, but
you're going to hide the subforms - how do you expect them to enter data
using something they can't see?
 
I don't want them to be able to actually "see" the subform
itself, where they WILL see it is when they go into the
main data entry screen. That's where I have it set up for
them to enter data.
Melanie
 
Melanie said:
I don't want them to be able to actually "see" the subform
itself, where they WILL see it is when they go into the
main data entry screen. That's where I have it set up for
them to enter data.
Melanie
Click to expand...

Do you mean see the subform in the database window? You can hide the
database window (Tools, startup) and set your main form to open on startup.

Also you should consider creating custom menus/toolbars for use throughout
your application.
 
Hello,
Yes, I mean the database window. Sorry for the
confusion. Actually, I have hidden the database window on
startup and have created special forms and menus that
guide the user, and they work fine. The only thing is, I
noticed that if a user exits the database by accident and
opens it pack up using file, open, then the database
window opens instead of the custom menu, and users can
then see all of the tables, queeries, etc. How do I
prevent this from happening? Any idea what has caused
this?
Thanks for your help!
Melanie
 
Melanie said:
Hello,
Yes, I mean the database window. Sorry for the
confusion. Actually, I have hidden the database window on
startup and have created special forms and menus that
guide the user, and they work fine. The only thing is, I
noticed that if a user exits the database by accident and
opens it pack up using file, open, then the database
window opens instead of the custom menu, and users can
then see all of the tables, queeries, etc. How do I
prevent this from happening?
Click to expand...

Since you have a custom menu, remove the Open item from the File menu.

Still, I don't see why that would bypass the startup settings.
 
Back
Top