Login page

[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?

 

[Bill Mosca, MS Access MVP]

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.

 

[Guest]

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.

 

[Bill Mosca, MS Access MVP]

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.