Log in Form
For my database, how would I create a form to be used as a log in? I understand I need a script that displays the login screen when the database is opened, but how do I create the password? I only require a password, no usernames.
You can use the script step "Show Custom Dialog Box".
However, the easier thing to do is setup under File > Manage > Security two different accounts. "Admin" which has full rights (including design changes) and "User" (use any name that you then share with anyone) and assign it the Data Entry Only privilege set. Give the Admin account a password and the User account a different password. You give the user account information to everyone else, but they cannot make changes to the structure of the database. The user then supplies the user name and password to login.
You can do it your way in the following manner:
The problem with the second method though is that everyone that logs in has Admin privileges so they can make changes to table design, relationships, and layouts - something that can be very, very bad.
Retrieving data ...