|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Access Visual Basic passwordI 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! 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! 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! > 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? |
|||||||||||||||||||||||