remove forgotten password for vba on accdb file.

hi
please help me.
2 years ago i made a database with protected vba(visual basic for application). i put expire date in my DB.now its expired !
but i cant remember the password. if i change my computers date to 1 month ago i can open and work with file.
so my question is:
how can i remove vba pass on my file? ( . ACCDB )
GHASEM GHIASIAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MacroShadowCommented:
Yes you can. Actually it is quite simple but EE rules don't let us help with cracking.
Just google "bypass vba password".
1
GHASEM GHIASIAuthor Commented:
my file doesnt need password when i open the file.i just want to open the vba code(password protected) and change the expire date.please let me know how to remove the pass or modify my file.
Untitled.jpg
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
As Macroshadow said, EE policy does not allow the Experts to help you to crack your password. There are utilities that can do this, but we can't suggest or recommend any.

VBA Passwords are not date-sensitive and do not have an "expire date". In other words, if you set a VBA password, it's set, regardless of the date, and you will always get the prompt until you remove the password. Same goes for a database password - if you set a database password, you'll always get the prompt until you remove it.

The image you show looks like the standard VBA Password window, but it's hard to say.

To remove a VBA password, you just open the VBA Editor and click Tools - <Your Database Name> Properties - Protection, and remove the VBA Password from the "Password to view project properties" box.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

PatHartmanCommented:
If the password is date sensitive, your own code is displaying the message.  Try resetting the computer date and then examining your code for the procedure that displays the message you posted.
0
GHASEM GHIASIAuthor Commented:
as attached.you can see that if i dont change my dates, we faced the expired program.thats why i want to open my accdb vbafile to change the dates and add some form to my db.
i beg you to help me to solve my problem.my Db volume is more than 700mb that i cant upload here.
expire.jpg
0
PatHartmanCommented:
I told you how to solve it.  Reset your computer date.  Then search for the message in the VBA code.  When you find the code that is generating the message either remove it or modify it so that you can change the expiration data.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
als315Commented:
You can try to press SHIFT (press SHIFT, start DB, release SHIFT) when open DB to skip autostarts
0
GHASEM GHIASIAuthor Commented:
my problem is i dont have the vba password .sheets are protected.i should find the vba pass then change the dates and modify it.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The message stating "This program has expired" has nothing to do with any Access passwords. That appears to be a program evaluation expiration. If so, then the only way to resolve that would be to contact the person you obtained the program through.

No one here can help you circumvent a password. We can give you the steps you can take to remove a database  or VBA password, as provided by Microsoft, but we cannot help you get around the expiration password.
0
GHASEM GHIASIAuthor Commented:
yes.please give me the steps that i can remove vba password
0
[ fanpages ]IT Services ConsultantCommented:
@GHASEM GHIASI:
yes.please give me the steps that i can remove vba password

Read the comment posted first (& seven hours before your last comment) within this thread:

"ID: 42406959"
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I told you how to remove a VBA password in my earlier comment:

https://www.experts-exchange.com/questions/29074188/remove-forgotten-password-for-vba-on-accdb-file.html#a42406980

Those are instructions published by Microsoft, so there is no restriction from providing those.

However, the last message you show (the one that reads "This program has expired") appears to be a message generated by your application, and indicates that the program is no longer valid. We can't help you get around that message, since it would seem to be something the programmer put into the program to protect their intellectual property.

The only way to resolve that is to contact the developer of the application to ask them how to resolve that matter.
0
GHASEM GHIASIAuthor Commented:
FINALLY i removed the password.
about expired program i found this code and changed the date:

If (Date > #11/19/2017#) Then
   MsgBox ("THIS PROGRAM HAS EXPIRED")
   DoCmd.Quit
thanks for your instruction.
1
PatHartmanCommented:
You're welcome.
0
PatHartmanCommented:
Instruction given
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.