Password on Command Button?

[Guest]

I have a shared network database only used by a particular department. All
department members have access to and and are able to edit the records via a
form, and that's the way it needs to be. However, the department manager
would like to restrict the users who can delete those records. Is there a
simple way to protect the records from being deleted except by selected
employees?

Any help you could provide would be greatly appreciated. Thank you!
Jen

 

[Rick B]

Please do a search. This is asked and answered very very often. In
general, this is a bad idea. Savvy users can easily look at the code to see
the password, or simply go around your form and open the data directly from
your table, a query, etc. A better solution is to implement proper
User-Level Security and restrict what users can and can't see/do in your
file. This means users log in one time when they open the file and they
have all their access to your database objects set. No need to make your
most senior users jump through hoops to get to data.

Read the previous posts on the topic for more details.