Access Visual Basic password

[Guest]

I see several posts on how to password protect visual basic code in Excel,
but I need to protect my code in Access. Is it possible to protect the entire
project with one single password that would prevent anyone from modifying my
code?

 

[Graham R Seach]

Don,

Sure. Open any code module. Then select Tools | Properties | Protection.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Office DevCon 2007. Sydney, Australia 3rd-4th Nov. Will you be there?
http://www.block.net.au/devcon/index.htm

 

[Tom van Stiphout]

On Wed, 19 Sep 2007 16:18:01 -0700, Don

Alternatively use the menu option to create an MDE. Ship your Access
solution as an MDE rather than an MDB, and there is no source code to
modify.

-Tom.

 

[Guest]

Well that was easy enough. I must have stared at that option a dozen times
and somehow missed it.

I want to secure my project so that others cannot modify it. This helps to
protect the code, and I have created a custom toolbar for the user to have,
but is there also a way to lock down the option to enter design or sql view?

I have tried converting to an MDE but I get an error saying that the project
is to big.