Urgent!! How do I create a login page in MS access 2003 /VBA

[Sebastian]

Hi guys! need help urgently. I am currently doing a project using MS
Access 2003. I have create most of the forms, queries and macros for
this project. What I need now is a login page to allow different users
to different forms. I know nuts about VBA and do not know how to create
a source code to lookup for the username and password (if possible,
masked it) in my tables. I do hope you guys can help me.

Here are the information:

Table Name: User
In this table, there are the two fields: Login and Password.

I have created a form named "Login"
In this form there are two fields.\

Field 1
Label: Login,
Text box: Login
Control source : Login ID (Text, Field Size=10)

Field 2
Label: Password
Test box : Password
Control source: Password (Text, Field Size=10)

Button
Command Button: Login Button



I really hope that you can help me!!!

 

[John Vinson]

Hi guys! need help urgently. I am currently doing a project using MS
Access 2003. I have create most of the forms, queries and macros for
this project. What I need now is a login page to allow different users
to different forms. I know nuts about VBA and do not know how to create
a source code to lookup for the username and password (if possible,
masked it) in my tables. I do hope you guys can help me.

If you're at all concerned about keeping your data secure, "rolling
your own" security system is probably NOT the best way to go about it,
even if you're a real VBA expert (you would have to be one to do this
at all well).

Have you looked at Access Workgroup security? It can do all that you
describe with little or no VBA code, although I confess that
implementing security is far from trivial.

Do investigte it before going too deep in a home-grown system, though:
keeping users out of your Password table (just as a start) is far from
simple! Check out

http://support.microsoft.com/kb/207793/en-us

It's for A2000 but the security model has not changed in later
versions.

John W. Vinson[MVP]