Secure Command Button

[Guest]

I have a command button on my main form and it opens another form. Is it
possible to password protect the command button or is there another approach?

Thank you

 

[Rick B]

You could, but what would prevent the user from simply opening that other
form? Or, what would prevent them from reading the code tied to your button
and seeing your password? What would prevent the users from opening the
table (that contains that form data) and seeing/modifying the data directly
in the table? Do you really want your authorized users to have to enter a
password every time they click that button? My higher-level employees want
their processes to be easier than the lower levels, not harder.

You can find previous posts out there that will tell you how to do this, but
generally it makes more sense to apply proper User Level Security and then
limit what your users can do. Each user would then enter their userid and
password only once when opening the file. They would then have the exact
access you specify and would not be able to easily get around any of it.

For details on how to apply a password to your button (if I have not
convinced you) do a search and read the previous posts on the topic. This
is a very common question, and there are lots of posts out there that will
tell you how to do it. Most include samples.