logins and security

[Brockite]

Dear knowlegable one's
How do i check and compare then confirm data that has been entered onto a form, with data that is in a access table.(for a login that checks username and password)

` Many thanks

The Brokite...

[Vit]

Open a recordset from user info table that will contain name and password fields. Search for entered user name. If found, then compare stored password with the entered one. In case they match login is correct else throw "Invalid password error". If user name is not found then throw appropriate error as well