Username/Password Verification

[Dan T.]

In a database, I have one table that allows a user to
create their user information, including a username and
password. I have another table that merely allows a user
to enter their username and password, and I want to use
the original user information table to verify that the
username and password are identical, thus gaining access
to other parts of the database. Is this possible, and if
so, does anyone know of a good tutorial for it?

Thanks in advance,

Dan

 

[John Nurick]

Hi Dan,

What you are saying doesn't really make sense. Given the way Access
tables work, there's no difference between "creating" a username and
password and "entering" a username and password. Are you talking about
*forms* rather than tables?

Either way, if you want to achieve any real security this sort of
approach won't work, because any knowledgeable Access user can easily
bypass it and look directly in the tables (including the table where you
store the passwords). For more than "token" security, you need to
implement Access's built-in "User Level Security" - but do it with great
care because if you do it wrongly you risk either ending up with no
security, or locking yourself out permanenetly out of your own database.

The Access Security FAQ includes explanations and step by step
instructions. Study it carefully before putting it into effect, and make
sure you have a fresh backup of your database.
http://support.microsoft.com/?id=207793
or
http://support.microsoft.com/support/access/content/secfaq.asp