User authentication

[tonyk]

I want to design a simple authentication system using usernames and passwords stored in a table called members.

I have a login form...if there username and password is in the table I'm able to open another form for them to update their member information. My login form opens up the maintenance form that is bound to a query (user_lookup) that looks up the username and password.

If their username or password is not in the table, I want to be able to send them to a form to register/signup...how can I do this? I assume I need to evaluate whether or not the username in the user_loop query results is null and then open the form I want. I'm not sure how to do this...macro? code?

Thanks

 

[Robert Dunstan]

Hi there,

I have an example of simple password authentication. It's not quite what you want but what it does is to make use of the DLookup function to return the password, permission level and login name to public variables.

Unfortunately it's too large to post here (116K) so if you want I can e-mail you a copy.

Rob