Microsoft Access Visual Basic Password

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Microsoft Access » Microsoft Access » Microsoft Access Visual Basic Password

Microsoft Access Visual Basic Password

Rate Topic

Display Mode

Topic Options

Author

Message

misty.mullins

Posted Tuesday, March 02, 2010 8:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 03, 2010 10:59 AM
Points: 2, Visits: 8

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.

Post #875238

Lowell

Posted Tuesday, March 02, 2010 9:08 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:59 PM
Points: 11,792, Visits: 28,078

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #875250

misty.mullins

Posted Tuesday, March 02, 2010 9:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 03, 2010 10:59 AM
Points: 2, Visits: 8

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

Post #875321

WendellB

Posted Wednesday, March 03, 2010 10:57 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:55 AM
Points: 109, Visits: 412

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.

Post #876190

WILLIAM MITCHELL

Posted Thursday, March 04, 2010 5:06 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 12:04 PM
Points: 1,442, Visits: 2,500

Take a look at Access Key
http://www.lostpassword.com/access.htm
$39 USD
I have used the older versions & it works very well.

Post #876720

« Prev Topic | Next Topic »

Permissions