Home All Groups Group Topic Archive Search About

Access Visual Basic password

Author
19 Sep 2007 11:18 PM
Don
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?
--
Thanks!

Author
20 Sep 2007 7:42 AM
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



Show quote
"Don" <D**@discussions.microsoft.com> wrote in message
news:2648063E-3879-4CF6-8DA8-DDA23BF54C7F@microsoft.com...
>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?
> --
> Thanks!
Author
21 Sep 2007 6:22 PM
Don
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.
--
Thanks!


Show quote
"Graham R Seach" wrote:

> 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
>
>
>
> "Don" <D**@discussions.microsoft.com> wrote in message
> news:2648063E-3879-4CF6-8DA8-DDA23BF54C7F@microsoft.com...
> >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?
> > --
> > Thanks!
>
Author
21 Sep 2007 2:27 PM
Tom van Stiphout
On Wed, 19 Sep 2007 16:18:01 -0700, Don
<D**@discussions.microsoft.com> wrote:

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.


Show quote
>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?

AddThis Social Bookmark Button