limiting access question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Melanie - 27 Aug 2004 18:56 GMT

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

Reply to this Message

Joan Wild - 28 Aug 2004 13:52 GMT

> Hello,
> I have created a database, and now I am trying to
[quoted text clipped - 7 lines]
> data entry on the main form, and hide the actual subform
> from them (I don't want them going in there)

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?

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Melanie - 30 Aug 2004 13:10 GMT

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

>-----Original Message-----
>> Hello,
[quoted text clipped - 12 lines]
>you're going to hide the subforms - how do you expect them to enter data
>using something they can't see?

Reply to this Message

Joan Wild - 30 Aug 2004 14:25 GMT

> 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

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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Melanie - 30 Aug 2004 18:21 GMT

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

>-----Original Message-----
>> I don't want them to be able to actually "see" the subform
[quoted text clipped - 8 lines]
>Also you should consider creating custom menus/toolbars for use throughout
>your application.

Reply to this Message

Joan Wild - 31 Aug 2004 14:10 GMT

> Hello,
> Yes, I mean the database window. Sorry for the
[quoted text clipped - 6 lines]
> then see all of the tables, queeries, etc. How do I
> prevent this from happening?

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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message