simple authentication form

[pdtit]

Hey,

Can anyone provide me with a complete procedure how to create an authentication form in MS Access ?

I have a table with username, password and profile (user or admin).

What's the VBA coding behind my submit button to go and check against the table to see if my username and password entered are correct ?
If these are correct, Access should store the profile.
The profile will be checked afterwards on other forms to see if the logged on user has access to some buttons or not.

Regards,

PDTIT

 

[JoaoTL]

Hi, in my site at

http://www.jtl.co.pt/downs/downs.htm#97

download the Login and Password Example. Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt