Login page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello i am using Access 2003. I have create a database which use a SQL
database. how can i create a login page (form) which will verify a username
and password in a users table i have created. If the username an password
does not match i would like it to give a customer error message. Can this be
done?
 
Since you are using SQL Server, I suggest you take advantage of its security
and use windows authentication unless you want to further secure the Access
front end with user level security which uses a workgroup file requiring a
user name and log in.
 
will i am using the SQL built into Small business server 2003 i also
installed SQL express. but securing the front end is not really an issue i
just want to more or less track who logs in and when.
 
My users all have local MDEs. Instead of maintaining a userID table, I just
use Environ() to get the user network log in. You can do an insert into a
table when the startup form opens.

I keep my startup form open all the time. I just hide it when it shouldn't
be see. That way I can use it's Close event to insert a "log out date and
time" for the user. This gives me a way to track usage.
 
Back
Top