Set/Change VBA password from VBA code in Access

mihir.dhandha · Apr 4, 2009

Hi friends,

I want to change/reset VBA password for Access VBA projects from VBA code itself.

While googling, I found few code to unlock Excel VBA project but I was unable to modify them for access.

Basically I want to set/remove VBA password of one mdb file programatically from another mdb file. I'll be having the VBA password, so this is not for recovery purpose.

Thanks in advance.

Mihir

SydneyGeek · Apr 5, 2009

According to this MSDN post you can set the DB password in code but yu must use DAO. ADO cannot do it.

http://msdn.microsoft.com/en-us/library/aa141813(office.10).aspxhttp://msdn.microsoft.com/en-us/library/aa14813(office.10).aspx

See if the above helps

Denis

mihir.dhandha · Apr 6, 2009

I think you have posted link for setting database password. I want to set VBA password.

SydneyGeek · Apr 6, 2009

I'm pretty sure that has to be done manually. I don't know of a way to set the VBA password in code.

Denis

Set/Change VBA password from VBA code in Access

mihir.dhandha

New Member

Excel Facts

SydneyGeek

MrExcel MVP

mihir.dhandha

New Member

SydneyGeek

MrExcel MVP

Similar threads

Forum statistics

Share this page

Set/Change VBA password from VBA code in Access

mihir.dhandha

New Member

Excel Facts

SydneyGeek

MrExcel MVP

mihir.dhandha

New Member

SydneyGeek

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock