Create Login Form

[AF]

I would like to create a form that would allow uses to
login to my database. A simple form that would require
username & password. The usernames & passwords would be
stored in the DB. The form would accept and then check
against DB. If correct, then entry, if not, then no
entry... Are there any help topics/pages on this?

Thanks.

 

[Graham Mandeno]

Have you investigated the option of user-level security? This will give you
secure user/password verification, and much more besides. Among other
advantages, you can assign uses to groups (roles) and then only allow
certain groups permission to read/update data, or to open certain forms and
other objects.

Check out the Access Security FAQ. You can read it online or download it
from: http://support.microsoft.com/?id=207793

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

 

[PC Datasheet]

Look up Password in the Help file.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel