I have a database in which the data is maintained by the secretary. She wants a way to require any user to log in using a password.
The idea is that she will have full access to the database, and others (the committee) will have access that allows them to print a list or send an email, but not let them change any data.
We aren't looking for earth-shattering security, and the committee are not likely to try hacking in.
I understand creating a password using Database Tools>Encrypt with Password, but don't know if that will allow me to make two