Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    security ? (Access 2000)

    I have a db that uses security to allow only certain users to open a form. I would like to have it open another form if the user is denied access to the secure form? How do you capture the permission failure? Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: security ? (Access 2000)

    How are you keeping the user from opening the form now? Ordinarily, you don't even offer the users a chance to open a form to which they have no permissions. I think you're going to have to explain more about what you're doing and what you want to accomplish.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: security ? (Access 2000)

    I have the form open by using a button on a menu. I have it set in the db's security to only alow certain users the ability to open the form. What I would like is if a user does not have access to the form another form opens showing the user other options. I have that form created I would just like it to open only for those users that or exculded from opening the secured form.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: security ? (Access 2000)

    The routine called by the button click should test to see what permissions the currentuser has by checking the group they belong to. Then you can open the appropriate form based on the permissions. Are you asking specifically how to do that, or did you just need an approach? The specifics depend somewhat on how you've set the Access security up.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •