protecting vba code

[Guest]

is there some way to protect vba code from unintentional modification. i
thought that there was but don't seem to be able to locate the method. i
tried vba 'help' but it seemed to come back empty.

-ted

 

[Larry Daugherty]

Convert your app to an MDE

HTH

 

[Guest]

larry, i are aware of your suggestion, but is there not some way that vba
lets you password protect the modules you created w/o going this route?

-ted

 

[George Nicholson]

In the VBE: Tools>(your db name) Properties>Protection

This allows you to set a password to prevent viewing of your code. It is
however, only as secure as simple password security (i.e., it can be hacked
without too much trouble). If that's good enough for your needs, feel free
to use it.

HTH,

 

[Guest]

To protect my code, I will use a Ruger or a Colt, whichever is closer, some
prefer Smith and Wesson. That works, too.

 

[Guest]

very helpful

-ted

To protect my code, I will use a Ruger or a Colt, whichever is closer, some
prefer Smith and Wesson. That works, too.

 

[Guest]

that's the one, by george!

THANKS!!

-ted

In the VBE: Tools>(your db name) Properties>Protection

This allows you to set a password to prevent viewing of your code. It is
however, only as secure as simple password security (i.e., it can be hacked
without too much trouble). If that's good enough for your needs, feel free
to use it.

HTH,

 

[Guest]

-security->workgroup (must deploy file security.mdw)
-convert from .mdb to .mde/.ade (remains only compiled code)


"Ted" a scris: