Unlock VBE Project

1 Oct 2008 5:52 PM

jlo

I inherited a database that needs modifications/changes. The creator of the
database is no longer with our company. I have received all the passwords
for the forms that are password protected.

When I try to see some of the event procedures, I receive a password form
that requires a password. I need to be able to add buttons and update the
event procedures on the forms. Of course the creator was let go without
anyone knowing the password for Visual Basic. Does anyone have any
suggestions? Even though it's not set up properly, it is huge and it works
for the users except the updates that are required.

I even tried to start a new database and import the objects (macros,
modules) and I received a message that I need to unlock the VBE project first.

Thanks.

1 Oct 2008 7:14 PM

Chris O'C via AccessMonster.com

I always see the advice to google for a tool that reveals the password.
There are tools for breaking Access user level security, Access database
passwords and some Microsoft Office applications' vba passwords. Trouble is,
none of them work for the Access vba password.

You have a few choices: find that long lost employee and get the vba
password, learn to live with the db as is, or rewrite the db app without all
the faults you now see.

Chris
Microsoft MVP

jlo wrote:
Show quoteHide quote

>I inherited a database that needs modifications/changes. The creator of the
>database is no longer with our company. I have received all the passwords
>for the forms that are password protected.
>
>When I try to see some of the event procedures, I receive a password form
>that requires a password. I need to be able to add buttons and update the
>event procedures on the forms. Of course the creator was let go without
>anyone knowing the password for Visual Basic. Does anyone have any
>suggestions? Even though it's not set up properly, it is huge and it works
>for the users except the updates that are required.
>
>I even tried to start a new database and import the objects (macros,
>modules) and I received a message that I need to unlock the VBE project first.
>
>Thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200810/1