Create Login Form

A

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.
 
G

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: [email protected]
Please post new questions or followups to newsgroup.
 
P

PC Datasheet

Look up Password in the Help file.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
[email protected]
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
 
Top