Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Dec 2009
    Location
    Iowa
    Posts
    33
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Lost password - how to open db

    Have an access 2002 database that was originally formed on an XP machine. Now trying to open it on my Win 7 machine. Either I've forgotten the password (originally made the db in 2005) or with the change in OS, the password has been lost/corrupted or what. Is there any way to open the db? I've tried Administrator, safe mode and talking to the machine :-(( but keeps asking for the password. Unfortunately I don't have any XP machines now. Need some suggestions.

  2. #2
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,077
    Thanks
    0
    Thanked 259 Times in 248 Posts
    The version of Windows and of Access shouldn't be a problem as newer versions nearly always can open older-version files.
    Unfortunately for users, database files along with others such as QuickBooks company files are passworded to prevent unauthorized use and there's not much that can be done with them without that password.

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    There are a number of ways to bypass database passwords. I assume that your database has a database level password that requires you to input a password to get the database to open. The following simple utility can be used to retrieve your database level password from an older database. Go to the following link: http://www.nirsoft.net/utils/accesspv.html
    At the bottom of the page, click the Download Access Passview Link. Save to a folder, unzip, install, and launch the app. Press the Get Password Button, browse to and then double click on your database and the app will provide you with your password. Post back if this does not work as there are other ways to get the password. ***OF COURSE - COPY YOUR DATABASE FIRST SO IT IS BACKED UP *** Good Luck.
    Regards,

    Gary
    (It's been a while!)

  4. The Following User Says Thank You to GARYPSWANSON For This Useful Post:

    artov10 (2016-06-10)

  5. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Hopefully, Gary's post will solve your issue. But it is possible that the database was setup to use User Security - do you get a prompt for both a UserID and a password, or just a password. If it's the latter, his solution should work. If it's the former, you will need to try to locate the .MDW file that was used with that database, and you will need to find other tools that will determine what userdIDs and passwords were established. Post back with what you find.
    Wendell

  6. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Thanks Wendell. Getting around a .MDW file is fairly easy as well. Artov10 - post back if neither solution works as there are other ways to obtain or bypass the password. Also, just curious, will a shift bypass work to open the database? (After starting the database, hold down the shift key). If it does work, then you should open in the views of tables, queries, etc. You could also try to copy all objects to a new database as long as there is not a VB password applied. Good Luck.
    Regards,

    Gary
    (It's been a while!)

  7. The Following User Says Thank You to GARYPSWANSON For This Useful Post:

    artov10 (2016-06-10)

  8. #6
    Lounger
    Join Date
    Dec 2009
    Location
    Iowa
    Posts
    33
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Gary,

    Sorry to be so long in getting back to you - got tied up with something else. But thank you, the nirsoft utility worked great. Thanks again.

    Art

  9. #7
    Silver Lounger RolandJS's Avatar
    Join Date
    Dec 2009
    Location
    Austin metro area TX USA
    Posts
    1,730
    Thanks
    95
    Thanked 128 Times in 125 Posts
    Quote Originally Posted by artov10 View Post
    Gary, Sorry to be so long in getting back to you - got tied up with something else. But thank you, the nirsoft utility worked great. Thanks again. Art
    Please tell us you are now writing in a lock-away log book exactly precisely the usernames and passwords of your various programs and databases.
    "Take care of thy backups and thy restores shall take care of thee." Ben Franklin revisited.
    http://collegecafe.fr.yuku.com/forum...-Technologies/

Posting Permissions

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