Code To Change User Permissions??

  • Thread starter Thread starter Damon Johnson
  • Start date Start date
D

Damon Johnson

Hi All,

Office XP Pro on Win XP Pro
Security established using user-level security wizard.

Problem: I have a form that I only want the users to be
able to read, not copy, update, delete. I had no problem
establishing the security for it, I just gave the users
Read-Only permissions.

The problem came when I developed another form. I do want
the users to be able to add and copy records, but not
modify or delete. In order to do this, I had to give the
users New Data permissions. Well, with Access
permissions, users are granted permissions of thier least-
restrictive group on all objects. Which for me means that
now users can add and copy on the form that I don't want
them to.

Question: Is there code that I can attatch to the forms
On Open event (or any other that may be appropriate)that
will allow me to change user permissions based upon the
username?

Is this a srcew-ball method? Will I have to establish
another workgroup information file? Will I have to put
the least restrictive form in one WIF and the more
restrictive form in another WIF? Does anyone have an
alternative that they'd like to suggest?

Many thanks,
Damon Johnson
 
Establish different user groups within your security. In
one allow the permissions you desire the users to have to
your form, in the other specify the other permissions that
you would want other users to have. Then assign the users
to the proper defined group, and your form will be safe.
This requires no establishing of a new workgroup file, you
just do it within the one with the security group and user
tools.

Casey
 
Back
Top