I am not sure how to do this. I am trying to do up a password form where there is a user name and a password. There will only be 5 user names, one being an admin. I seen it in the Running Microsoft Access 2000 book (it's just a reference manual) but could not figure it out.
password form for multiple users
- Thread starter Rudeman76
- Start date
boblarson
Smeghead
- Local time
- Today, 05:19
- Joined
- Jan 12, 2001
- Messages
- 32,040
Are you trying to lock down items within or what? If so, I would look into using Access Security, or else it gets a little complex with building your own security in.
If you want to build it in, then you should create a table for the names and passwords. Then, you would have the password form do a DLookup when the user puts in the info and presses OK. It would look up the password from the table and then see if what they entered matches. If so, then you can set your code to move on, if not have a message box appear to ask if they want to try again and if they do go back to the password form and if not quit the application. And if you want only certain users to get access to different items that becomes even more complicated as you have to run a check each time someone tries to do something to see if thy have the permission level to do it.
So, again you probably want Access Security and if you run the Access Security Wizard it will help you in setting that up. But, I would definitely make a copy of your database BEFORE starting anything so if you mess something up you can not be hosed.
If you want to build it in, then you should create a table for the names and passwords. Then, you would have the password form do a DLookup when the user puts in the info and presses OK. It would look up the password from the table and then see if what they entered matches. If so, then you can set your code to move on, if not have a message box appear to ask if they want to try again and if they do go back to the password form and if not quit the application. And if you want only certain users to get access to different items that becomes even more complicated as you have to run a check each time someone tries to do something to see if thy have the permission level to do it.
So, again you probably want Access Security and if you run the Access Security Wizard it will help you in setting that up. But, I would definitely make a copy of your database BEFORE starting anything so if you mess something up you can not be hosed.
Similar threads
