Forum Discussion

txgeekgirl's avatar
txgeekgirl
Copper Contributor
Mar 16, 2022

Recovering a VBA protect password

 

I wrote a database in 2009/2010 in 2007.  I migrated it to 2010, changed it to an accdb and password protected the VBA. In 2017, I left the company, handed over all of my passwords, and left my code in another's hands. 

 

In Sept 2021, they asked me to please come back, I did, and the password to the DB I am trying to recover was lost.

 

I have tried using HxD, which doesn't work with accdb. 

 

How can I recover the password? 

 

 

 

 

 

 

 

5 Replies

  • MCarr10's avatar
    MCarr10
    Copper Contributor
    I have not tried this tool, I came across it in a web search. It says it supports both mdb accdb format. Please proceed with caution and do all necessary due diligence.
    https://www.cocosenor.com/products/access-password-tuner/
    • isladogs's avatar
      isladogs
      MVP

      MDB passwords are trivial to hack. However, that isn't the case for ACCDB passwords which, since A2010, use 128-bit encryption.

       

      I have tried the cosenor password recovery tool for research purposes. The utlilty uses a brute force approach to test every possible combination of passwords in turn until it finds something that works. So if your password is reasonably long/strong this can take days/months or even years to complete ...unless you can provide clues to narrow down the search. 

      As an experiment I tested it on one of my own databases whose 10 character password I already knew. I left the utility running on a spare workstation for almost 48 hours. It had only tested a small % of the possible values before I terminated the search.

       

      For a guide as to the time needed to hack a password using brute force, see https://www.linkedin.com/posts/cbtech-support_ever-wonder-how-long-it-would-theoretically-activity-6715288518240845824-Aiyx/

      • txgeekgirl's avatar
        txgeekgirl
        Copper Contributor
        We tried a BruteForce tool... it recovered 1 character in a day. The password was at least 10 characters with all the bells and whistles.
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor

    txgeekgirl You may be out of luck. If you can prove that you created the accdb, or that it belongs to your employer, you might be able to get help recovering the VBA from a company like Everything Access, although that's not their primary focus. They specialize in recovering mde and accde files. They will require proof of ownership as a precondition, if they can tackle your particular problem.

Resources