Strong Password Secure Criteria in MS Access Ultimate Login System
Vložit
- čas přidán 18. 04. 2024
- Proudly presenting the unique video on how to handle Duplicate usernames with the Secure Password criteria in the Login System. In this video, we are going to upgrade our login system with ultimate and unique login security features regarding advanced Password criteria in MS Access.
📚 Downloads
skillheader.com/download-skil...
✉ contact@skillheader.com
Explore Projects and Blog with Source Code:
🌍 Website: skillheader.com/
#access #strongpassword #loginsystem
______________________________________________________________________________
Icons by: icons8.com/icons
Images by: www.freepik.com/
📚 Downloads
skillheader.com/download-skillheader-projects-tutorials/
Explore Projects and Blog with Source Code:
🌍 Website: skillheader.com/
I have noticed on several of your projects that folks are asking for the download files for projects underway. While it would make things easy, I am in the camp that makes it too easy and will detract from the learning process. It feels so much better to achieve success by watching, listening and typing. When you get stuck, reaching out to others will go a long way to seeing what we miss. And for the record we all will make mistakes!
i'm excited great work
Yes, I'm excited!
Nice work I have added this to the Accounting Business and YES im excited!
thanks lot for everything you are the best
Am Ecited too 👌
Another Marvelous video!!! I enjoyed every second of it!!!
Would be awesome if you have time, to teach us how to make a hospital supplies database! I mean regular supplies not only medecines !
Thank you and keep up the good work buddy ❤
Thank you very much for your support and love for my channel. Your suggestion is considered. Stay tuned.
very very goob. I become an expert thanks to you
I am excited 😊😊
Your effort is appreciated sir,
If you have time, schedule a lesson on MS Access Security Limits
What are the maximum security limits for MS Access Forms?
Thank you for your support. I did not get you, What do you mean by security limits?
@@skillheader
When we want to open the database
so when open it should show the dashboard and the security is not destroyed by holding the (shift button).
Very nice thanks
can you add a checkmark on the register when meet the criteria? i.e. if you use a special character the checkmark will be visable...
Thanks great work. For entering the password and getting the length of the password I used len(me.r_password.text) as well for the asc(mid(me.r_password.text)) . This way it does not say there is a null value
I keep getting error messages that state a variable has not been defined for "TL, upper, lower, nm, special or cnt". I created a DIM line for each as integers and that is not counting either. I do lose the "variable not defined" error, but my count shows 0 and will not count from there as I type in different characters.
What am I doing wrong. I am using access 365.
Here is my code:
Private Sub cmdCount_Click()
'Number of Character Length
Dim TL As Integer
TL = Len(Me.r_password)
Dim i As Integer
Dim s As Integer
Dim upper As Integer
Dim lower As Integer
Dim nm As Integer
Dim special As Integer
Dim cnt As Integer
'There should be at least 1 Upper, 1 Lower, 1 NUmber and 1 Special Character
For i = 1 To TL
'Find the 4 methods for characters using ascii codes
s = Asc(Mid(Me.r_password, i, 1))
Select Case s
Case 65 - 90
upper = 1 'For Uppercase Letters
Case 97 - 122
lower = 1 'For Lowercase Letters
Case 48 - 57
nm = 1 'Cannot use number as it is a variable built in
Case 33 - 47, 58 To 64, 91 To 96, 123 To 126
special = 1 'For Special Characters
End Select
Next i
cnt = upper + lower + nm + special
Me.txtCount = cnt
End Sub
Please copy the code here if possible or email me.
@@skillheader
Private Sub cmdCount_Click()
'Number of Character Length
Dim TL As Integer
TL = Len(Me.r_password.Text)
Dim i As Integer
Dim s As Integer
Dim upper As Integer
Dim lower As Integer
Dim nm As Integer
Dim special As Integer
Dim cnt As Integer
'There should be at least 1 Upper, 1 Lower, 1 NUmber and 1 Special Character
For i = 1 To TL
'Find the 4 methods for characters using ascii codes
s = Asc(Mid(Me.r_password.Text, i, 1))
Select Case s
Case 65 - 90
upper = 1 'For Uppercase Letters
Case 97 - 122
lower = 1 'For Lowercase Letters
Case 48 - 57
nm = 1 'Cannot use number as it is a variable built in
Case 33 - 47, 58 To 64, 91 To 96, 123 To 126
special = 1 'For Special Characters
End Select
Next i
cnt = upper + lower + nm + special
Me.txtCount = cnt
End Sub
There are 2 mistakes.
------
Put
i=0
before the "For" statement
------
Do not use dash "-" in the case
Case 65 - 90
Use this
Case 65 To 90
-----
I failed to say thank you….so THANK YOU, it worked!
Nice forms, great code for the criteria, but the password may not be stored in plain text in the table under any circumstances.
Anyone with access to this table also has access to the passwords of all users
The problem is the human being!
Idea, check out the videos from your colleague
Sean MacKenzie
How to Encrypt and Hash Passwords in MS Access
czcams.com/video/2VrFXQd7xDQ/video.htmlsi=yyupEPutb0UvCODP
Thanks for your comment. MS Access objects like Tables, Queries, Forms, Reports, and Modules can be hidden programmatically, code can be locked, and even the whole application can be converted into an exe file. No need to involve any third-party application to encrypt because it has to be done from all frontend devices.
why do all your videos have a download link - but no downloads ?
The completed projects can be downloaded by email. Refer to email me.
@@skillheader Your wording of this asks us to send you the code. Why not just link to the example file ?