Block Certain Users from Certain Forms

[Ripper]

I have 5 types of users in my database. I went through and gave permissions
to teachers to open all the forms they need, but not the office forms. Then
I went through and gave office permissions to all the forms they need. No
problem there.

When I log in as a teacher though, I can still open forms that I did not
give them permission to open. WHY!? It is driving me crazy. I am using
Office XP, but the database is in 2000 format.

Please keep me from the padded room and the jacket that buckles in the back.

 

['69 Camaro]

Hi.

When I log in as a teacher though, I can still open forms that I did not
give them permission to open. WHY!?

The users in the "Teachers" group are also members of a group that can open
the "Office" forms. Did you take all of the permissions away from the
"Users" group for these forms? Every user is a member of the "Users" group
by default.

Please keep me from the padded room and the jacket that buckles in the

back.

Sorry. We'll have to charge for that service. ;-)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Ripper]

I'll have to check. The file is actually at home. Could you check on this
tomorrow and see if your suggestion was the answer or if I am actually in the
cell with the "special" jacket.

RIP

Hi.

When I log in as a teacher though, I can still open forms that I did not
give them permission to open. WHY!?

The users in the "Teachers" group are also members of a group that can open
the "Office" forms. Did you take all of the permissions away from the
"Users" group for these forms? Every user is a member of the "Users" group
by default.

Please keep me from the padded room and the jacket that buckles in the

back.

Sorry. We'll have to charge for that service. ;-)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

['69 Camaro]

Sorry. I wasn't available yesterday to check. But since I see that you
posted a few more messages yesterday, I'll assume that you can freely reach
the keyboard with your fingers and that "special" jacket is not hampering
you in any way. ;-)

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

I'll have to check. The file is actually at home. Could you check on this
tomorrow and see if your suggestion was the answer or if I am actually in the
cell with the "special" jacket.

RIP