Password Question Second Eddition

ok guys need a little help here im trying to figure out... some have helped but i need to know ok what i did was hard code passwords and i want to know how i can do this in a mdb so it searches for the username and password there and then sees if it equals out.... and i was trying to give them the option to update there passwords if anyone has any ideas please let me know :)

Thanks

Hi,

Make a small table with 2 fields in it "UserName": Text and "Pass": Text and name it for exemple "Users".

Make an app that can add modify and remove your users.

When you want to know if the user exists run anm SQL SELECT line where you specify that UserName = the input text, same thing with the password.

If your SQL comand returns BOF = true and EOF = true then your supplied username and password does not exist ! You can also use security levels to know if user1 can delete user2...

Hope thats what you wanted...