Link to home
Create AccountLog in
Microsoft Access

Microsoft Access

--

Questions

--

Followers

Top Experts

Avatar of GHASEM GHIASI
GHASEM GHIASI๐Ÿ‡ฎ๐Ÿ‡ท

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 )

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of Joe HowardJoe Howard๐Ÿ‡บ๐Ÿ‡ธ

Yes you can. Actually it is quite simple but EE rules don't let us help with cracking.
Just google "bypass vba password".

Avatar of GHASEM GHIASIGHASEM GHIASI๐Ÿ‡ฎ๐Ÿ‡ท

ASKER

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

Avatar of Scott McDaniel (EE MVE )Scott McDaniel (EE MVE )๐Ÿ‡บ๐Ÿ‡ธ

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.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of PatHartmanPatHartman๐Ÿ‡บ๐Ÿ‡ธ

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.

Avatar of GHASEM GHIASIGHASEM GHIASI๐Ÿ‡ฎ๐Ÿ‡ท

ASKER

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

ASKER CERTIFIED SOLUTION
Avatar of PatHartmanPatHartman๐Ÿ‡บ๐Ÿ‡ธ

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of als315als315๐Ÿ‡ท๐Ÿ‡บ

You can try to press SHIFT (press SHIFT, start DB, release SHIFT) when open DB to skip autostarts

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of GHASEM GHIASIGHASEM GHIASI๐Ÿ‡ฎ๐Ÿ‡ท

ASKER

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.

Avatar of Scott McDaniel (EE MVE )Scott McDaniel (EE MVE )๐Ÿ‡บ๐Ÿ‡ธ

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.

Avatar of GHASEM GHIASIGHASEM GHIASI๐Ÿ‡ฎ๐Ÿ‡ท

ASKER

yes.please give me the steps that i can remove vba password

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


@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"

Avatar of Scott McDaniel (EE MVE )Scott McDaniel (EE MVE )๐Ÿ‡บ๐Ÿ‡ธ

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?anchorAnswerId=42406980#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.

Avatar of GHASEM GHIASIGHASEM GHIASI๐Ÿ‡ฎ๐Ÿ‡ท

ASKER

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.

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of PatHartmanPatHartman๐Ÿ‡บ๐Ÿ‡ธ

You're welcome.

Avatar of PatHartmanPatHartman๐Ÿ‡บ๐Ÿ‡ธ

Instruction given
Microsoft Access

Microsoft Access

--

Questions

--

Followers

Top Experts

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.