How to remove password protected from VBA modules (2 Viewers)

[BenMason]

I inherited an Access database that is password protected. I can open it, view tables, queries and forms. But, when I click on a form event to see the code, I am prompted with enter the password. I do have the password, and it works.
My issue is that I want to copy the forms from this database to another database and it gives me the message the database is password protected but nowhere to enter the password.

I clicked file, Info to get to the password but the decrypt is not there. Only encrypt with password. I can't figure out where the password is located. Has anyone run into this?

Thanks,
Ben

 

[Galaxiom]

What is the extension type of the file?

 

[BenMason]

accdb

 

[theDBguy]

I clicked file, Info to get to the password but the decrypt is not there.

I think you went to the wrong place. You need to go the VBA window and then from the menu, go to Tools > Database Properties and then click on the Protection tab.

 

[BenMason]

You are right. I was looking in the wrong place. I found it and was able to unlock it and copy the forms to another database.
Thank you!!

 

[theDBguy]

You are right. I was looking in the wrong place. I found it and was able to unlock it and copy the forms to another database.
Thank you!!

You're welcome. Glad we could assist. Good luck with your project.