Access Login

[Cal Mc]

How can I make a login form that works for all users in a table and their
corresponding passwords? All I have is a login form where you have to go to
the relevant record, say, I want to enter the username and password of the
person in record 123, I have to go to 123 to do it. Otherwise, It accepts
all passwords from all users. What do I do?

 

[Jerry Whittle]

I suggest using the built-in Access user level security instead. No use
reinventing the wheel.

 

[SubyRuby]

How can I make a login form that works for all users in a table and their
corresponding passwords? All I have is a login form where you have to go to
the relevant record, say, I want to enter the username and password of the
person in record 123, I have to go to 123 to do it. Otherwise, It accepts
all passwords from all users. What do I do?

If you decide you don't want to use Access user level security, try
this: http://www.databasedev.co.uk/login.html

I followed the directions found there, and it worked great. I also use
the login name (for the current user after they sign in) and store it
in a hidden form. Then, when I want to create a timestamp on my form
to store who made the most recent changes, I can refer to the current
user.

Hope this helps!

 

[Allan Murphy]

You could also look at message 10 on this link
http://forums.databasejournal.com/showthread.php?t=45488