Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Microsoft Access Visual Basic Password Expand / Collapse
Author
Message
Posted Tuesday, March 2, 2010 8:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 3, 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
Posted Tuesday, March 2, 2010 9:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 7:44 AM
Points: 12,910, Visits: 32,015
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
Posted Tuesday, March 2, 2010 9:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 3, 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
Posted Wednesday, March 3, 2010 10:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:50 AM
Points: 144, Visits: 525
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!
Post #876190
Posted Thursday, March 4, 2010 5:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 5:58 AM
Points: 1,509, Visits: 2,687
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 »

Add to briefcase

Permissions Expand / Collapse