Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Set Security now I cant get in (Access 2002)

    I was setting up security on my database and now cannot get in. I saved a copy on my desktop but found that the security I was setting for this database (I separated it into a folder by itself) in affecting all of my databases regardless of where the folder is. I have printouts of what I did but no combination of user/password will work.



    Any ideas?

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Set Security now I cant get in (Access 2002)

    I wonder if you've changed your system.mdw file. Can you get a virgin copy from someone else's computer?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Ventura, California, USA
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Set Security now I cant get in (Access 2002)

    No,

    Unfortunately that was deleted. How do I recover from this??

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Set Security now I cant get in (Access 2002)

    Well, that's probably part of the problem.
    Start Access, Go to Tools, Security, Workgroup Administrator
    Choose Create
    Create a without a Workgroup ID
    call the file system.mdw
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Set Security now I cant get in (Access 2002)

    <!profile=WebGenii>WebGenii<!/profile> has indicated the first step. But you are like to still have troubles. How did you go about securing your database - we will need to know all the things you did? Also, did you use the Security Wizard, or did you do things manually? You might also want to look at our brief User Security Tutorial and Jack MacDonald's User Security paper.
    Wendell

Posting Permissions

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