Hi Richard, Im trying to balance between family and building the database. So far doing good. Im watching the security videos and got 6 done. One question several people had including the director. She wants everyone to have the ability to have the option of changing their own password. I didnt see that in the seminar. Do you have a video on how to add that for each person? Thanks.
You can just create an Account Form which then allows you to update your own password.
You would have to lock it down and make sure that you check the current password and that the logged in user can only update their own record.
Adam Schwanz
@Reply 5 years ago
Yea you would just need to check if the current logged in user is correct the same way the seminar teaches you. For something like
User:
Current Password:
New Password:
Repeat New Password if you want
Check the user and current password are correct, and then instead of opening your main menu you would put a currentdb.execute or runsql statement there to change the password value of that user in the table.
Yeah, you could even do it with one button and an InputBox to ask their new password. I didn't cover things like that because, honestly, these are beginner VBA topics. The goal of the Security Seminar was to teach you the security stuff. I cover things like this in the first few Developer levels.
Scott Axton
@Reply 5 years ago
Mark -
Richard covers a VERY good example of this in the extended cut of String Functions You really do need to become a member. This alone will save you hours of work.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
