Topic: SQL code for login form

Hello, please can anyone help me with an SQL code for login form. I want a situation where more than one users can login and access my database. Meaning, the username box will be combo Box while the password field will be a textbox. If a username enters a wrong password 3 times, the database application will close. I dont really know much about coding. Regard!!

2 (edited by derek 2017-07-03 19:54:55)

Re: SQL code for login form

Hello Mr Slim,
You could try doing something like this (please see attached) but there are many other ways.
The following users/passwords have already been set up:
Derek / 123
Neil / 456
Sam / 789
Peter / 111
Ken / 321
Dave / royce
Slim / mvd
In my example, a user who enters a password incorrectly 3 times is also removed from the drop-down list but you might choose to do it differently.
Hope this helps,
Derek.

Post's attachments

Attachment icon slim login.zip 572.59 kb, 100 downloads since 2017-07-03 

Re: SQL code for login form

I will test it. still then, I say thank u bro

Re: SQL code for login form

I can't open it. Any idea on how?

Re: SQL code for login form

Hi,
I've just downloaded it and tried it and it's okay for me.
What error message are you getting when you try to run it?
Derek.