Hi all,

I am currently using an Access database to store usernames and passwords for users. The login works, but it has no way of checking if the username submitted through the login form exists in the database. If the username does not exist, the user still cannot access the protected pages because the "checking" page does not detect the proper value in a session variable. My question is: does anybody know how to check and see if the username entered in the login form existis in the database before proceeding further?

All help is appreciated.

Thank You.

Let Access do that for you. Send down a query like "Select * From Users Where Username = ?" and then it should either return zero records, or one. If the user doesn't exist by name, the query won't return any data, and the recordset you're using to pull the data will immediately set EOF to true.