Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Locked Out (Access 97sr2 (Win2000))

    This is going to sound really stupid (because it IS really stupid), but in trying to learn how to set passwords and other security settings for users in a database, I seem to have passworded myself totally out of Access. I can't even open the program! It asks for a password, but NONE of the passwords I use will work (I've tried the password I set for the admin, the password I set for the users, and the Unix password that controls my very existence here at work, as well as obvious misspellings of each, caps-on and caps-off, etc.).

    I might get old, gray, and wrinkled before our IT department helps me out with this one, but I thought one of you smart Access people might have a good laugh at my expense (rightly so) and then think of some way out of this for me.

    The database is located on a server, not my desktop PC. Do you think re-installing Access on my PC will solve this problem? Or is that wishful thinking?

    I did make a backup copy of the database before I messed around with it. Will that help in any way?

    Is it obvious that I'm grasping at straws?

    Thanks!

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

    Re: Locked Out (Access 97sr2 (Win2000))

    The first question is did you set a database password, or did you apply the security wizard and really lock down the databae. If it was just the first, there is a database password cracker that can be downloaded for a small fee. Do a search in the forum on that topic. If it's the latter, or both, it's probably a good thing you made a backup - hopefully the data is identical in both. As to reinstalling Access, that won't help, and may only make the problem work. You might want to look at the MS White paper on Security - several people have made references to it in the last 2 or 3 days. Hope this helps - would want you to be gray, wrinkled, and old like me.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked Out (Access 97sr2 (Win2000))

    If this is User Level Security and this is indeed your database, email me a copy of your security file (.mdw) that you have set up. I will email you back all the User Group and User Password information.

    Remember ..... "it is illegal to break into a secured database without the permission of the owner".

    rdhicks@mindspring.com

    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked Out (Access 97sr2 (Win2000))

    Wendell,
    I didn't use the security wizard.

    Today's issue of Woody's Office Watch included a link to an advertiser specializing in recovering lost passwords. I downloaded the demo version of the software, which indicates that no database password was set.

    Why do you think reinstalling Access might make the problem worse? I ask this because my IT department has hinted that they think I've got a bad Office install (I've also suffered a totally unrelated Word template problem), so I'm afraid reinstalling Office will be their first crack at "helping."

    Thanks.

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

    Re: Locked Out (Access 97sr2 (Win2000))

    If you don't have a database password set, then it must be Access security, which means you apparently applied a password to the Admin account that is normally used with Access. When you do that and then exit, you must supply a password each time Access first opens a database (in 2000). When that is done, the System.mdw file is modified to store the user and password info you entered. If you reinstall Access, and it's not from the same exact CD that was used to install Access in the first place, the new System.mdw file will have a different ID number, and you would definitely not be able to get into your database. If you really want to recover your database, do as Ricky Hicks suggests, and send him your system.mdw file.

    In your initial post you indicated you had a backup of your database. Assuming it's current, I would make another copy, read through the white papers noted in several recent (last 2 days) posts that describe Access security in some detail, and then try securing your copy of the database again. It's also important to determine exactly what you want to accomplish with security. That is, do you want to keep some users from performing certain tasks, do you want to prevent users from working with tables directly, do you want to prevent users from seeing the design of forms or reports, do you want users to be able to create their own queries, and are users allowed to see code. Access security handles all these issues as well as others, but it can also get you in a heap of trouble, as you discovered. If any of this sounds like nonsense, repost and I'll do my best to amplify, explain and confuse! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Wendell

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

    Re: Locked Out (Access 97sr2 (Win2000))

    Anne

    By the way, we use Access security in nearly every project we build. The principal reason is that we can track who did what to whom with the CurrentUser() function. It's amazing what ownership people take if they know that their mistakes can be identified. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Wendell

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked Out (Access 97sr2 (Win2000))

    If it is an Access installation problem and no password or security where used, copy you database to another PC and see if it open.
    Francois

  8. #8
    Star Lounger
    Join Date
    Aug 2001
    Location
    Maine, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Locked Out *SOLVED* (Access 97sr2 (Win2000))

    PROBLEM IS SOLVED!!! <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>

    And the solution was staring me in the face the whole time. Typing in a password (even the correct password, as so kindly verified by Ricky) generated an error message that said "Not a valid account name or password." And because I had just set a password, that's what I was focusing on. HOWEVER, when the password dialog box popped up, it showed the account name "anneb" (assigned to my Unix account here at work). But the password was tied to the name "Admin." So it wasn't really a password problem at all--it was the account name I was using.

    EUREKA! I just changed the user name from anneb to Admin, put in the password, and I'm in.

    So thank you, Ricky, for verifying my password for me. And Wendell, you are my hero for spending so much time explaining security issues to me; I promise to read those white papers so I won't be making another bonehead mistake like this one. Francois, I also appreciate your input. You guys are the best.

    Humble thanks to all of you. <img src=/S/kiss.gif border=0 alt=kiss width=34 height=15>

Posting Permissions

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