Security Permissions

[Guest]

So I've come to the end of a long road. A database some 10 months in the
making. The database requires each user to have a set of limitations.
Everything works great for the administrators and the full data users. I'm
getting hung up on the read-only users though. Some forms are insert forms
so Access will do one of two things: Treat it as an error and fail (which I
can put in an error handler and redirect it to the previous form) or it will
display a blank form in which the user can only close out of (and since close
buttons are disabled they exit Access). And I was wondering what the best
solution would be. It wouldn't be a "null" situation would it? and I
imagine the bit of code would appear on the open/load event. Thanks in
advance.

 

[Van T. Dinh]

Personally, I prefer to hide / show the CommandButtons depending on the
user's permissions. For example, if the user has Read-Only permission, all
the "Add New" CommandButtons will be hidden and therefore not available to
the user.

 

[Guest]

That sounds like the best course of action. You wouldn't by chance know the
syntax for the if statement would you?

like:

If User.Group = Read-Only User Then.....

I know that's incorrect syntax, but is it something along the lines of that?
Thanks again.

 

[Van T. Dinh]

I may not work that way since a User can belong to more than one group.

Check Access VB Help / DAO section on the Groups Collection / Group Object
and Users Collection / User Object.

 

[Joan Wild]

There's code in the security FAQ you can use to determine if a user is a
member of a group. Just be careful as a user may be a member of more than
one group.
http://support.microsoft.com/?id=207793