Password verification from VB form to SQL table

[Viguela]

I have a form where user need to input "EmployeeID" and "Password". At submit button click EmployeeID and Password need to be verify if they are correct on a SQL table.
I need HELP! ASAP!. Thanks.

 

[bbosley]

If you are looking to verify the userid and passoword against a sql table of usenames and passwords you just need to select the userid from the table and verify the password returned is the same as the one entered. I would create a function that sends 2 parameters, Username and password and returns a boolean to tell you if the username and password match with what is in the table.

If you are trying to validate the username and password against the server login userid and password you will need to use a windows API call.

bbosley