Microsoft Access Visual Basic Password

  • Had a SA set a password on the Visual Basic Script in all of our Access databases and then he left. We are trying to move the back end over to a new server but we can't get around the password. Please Help.

  • he's just gone from the company, not dead. We had almost the same thing happen, guy left and noone knew what to do.

    There's always the thought that someone leaves you can't talk to him any more, like he has leprosy or something, and that's not true.

    The fastest way is to simply call him on the phone; chances are he'll know it off the top of his head.

    After you get the information, you'll want to start documenting things so it's easier to recover from in the future.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • We did talk to the guy but he either doesn't remember or wont help. He did not leave on the best of terms.

  • I take it the password is set on the VBA project in your Access front-end. If your backend tables are in SQL Server, and the front-end isn't doing table linking in code, then you should be able to use the Linked Table manager to connect to a new back-end server. If table linking is going on in code, or if you have ADO connection strings in the front-end, then you will need to recover the password. There are tools available to retrieve the password that you can find with a web search. Note that this also is dependent on the version of Access being used, and whether it is an MDB, ADP, or the 2007 formats.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

  • Take a look at Access Key

    http://www.lostpassword.com/access.htm

    $39 USD

    I have used the older versions & it works very well.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply