form login password

[Guest]

dear friends
i have an table name Employees
field employees (text)
" password (text)
table 2 name Loggers
field employeename (text)
date (date)
password (text)
i have created an form to use as an main form based on loggers table and
placed other command buttons on its header to access other forms and for
reports
Now how to match the password of employees who were logged in to the
data base respectively?
and unless the password not matched no command buttons should enable
how to do this please.
balu.

 

[RBear3]

Why reinvent the wheel?

Access has password security built in. You should implement user-level
security. Trying to roll your own as you have done will uncover many many
holes. What prevents your user from simply opening the table and viewing
the data or changing it? What keeps them from building their own queries,
reports and forms and simply bypassing yours?

If I were you, I would read and re-read the following, make a backup of your
files, then dive in and implement ULS...

Security
Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm

 

[Guest]

thanks for replay,
what actually i want is an monitoring system that can record all the
visitors.
and all authorised visitors will be given an password by the company.
while loging in how to tally the user name and pass word ?
(2) regarding data base security it has been secured with password.
(3) kindly advise more about the user level security for many data base
users
yours balu