Write-Protect

[Guest]

Good afternoon
I'd like to know if there's a way to write-protect forms (a la keep them from being deleted from the object window). I'm sending a copy of my database to someone and I'd like the copyright form to remain immutable

Thank you in advance
Derek

 

[Rick Brandt]

Good afternoon,
I'd like to know if there's a way to write-protect forms (a la keep them

from being deleted from the object window). I'm sending a copy of my
database to someone and I'd like the copyright form to remain immutable.

Send them a copy compiled into an MDE and then no code-based objects can be
deleted, changed, or even viewed in design view. If for some reason you
have to send them an MDB then you would have to apply User Level Security
(big undertaking if you're not already familiar).

You could simply hide the form. That will work if the people don't know
much about Access.