Microsoft Access Visual Basic Password

Question

Microsoft Access Visual Basic Password

misty.mullins

SSC Enthusiast

Points: 146
More actions
March 2, 2010 at 8:57 am

#217218

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.

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

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!

misty.mullins SSC Enthusiast Points: 146 More actions · Answer 2

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

WendellB SSCrazy Eights Points: 8678 More actions · Answer 3

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!

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 4

Take a look at Access Key

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

$39 USD

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