Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Location
    Knoxville, Tennessee, USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security Wizard (XP 10.4302.4219 SP-2)

    My goal is to setup my database so that others can log on and enter data and read data but cannot do anything else. Only two of use would be able to function as admin people.

    I am trying to use the security wizard to set various permissions along with logon procedures. I work my way through the wizard and when I am suppose to get a One-Step Security Report it displays with errors and no information. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> I pick all the defaults as I go along just to test. Once I finish I cannot sign into the database because it seems to be assuming that I am a user without permission. So I delete everything and restore that backup that the wizard created at the beginning. <img src=/S/aflame.gif border=0 alt=aflame width=16 height=16>
    Any help would be appreciated. I am not even sure what information would help to assist you guys in helping me! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Security Wizard (XP 10.4302.4219 SP-2)

    Microsoft has a informative and comprehensive document on security available for download, see <!mskb=207793>Microsoft Knowledge Base Article 207793<!/mskb>.

    Access moderator <!profile=WendellB>WendellB<!/profile> has a tutorial on security (with lots of useful links) on his website (there is a link in his profile).

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

    Re: Security Wizard (XP 10.4302.4219 SP-2)

    Did you create a new workgroup file (mdw) for this security project with a name other than system.mdw? Did you join that workgroup before trying to use the wizard? What user are you trying to login as? I concur with Hans's suggestions about white papers and Wendell's tutorial. Security can be terribly confusing when you first start working with it in Access.
    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
  •