Ask for username and password

[stuck]

I would like to create a table in access which has two
fields, username and password. I will assign these. When
the user accesses the database I would like to ask them
for a username and password and then check the table to
see if these are correct. Can someone help me do this.
Thanks.

 

[Rick Brandt]

I would like to create a table in access which has two
fields, username and password. I will assign these. When
the user accesses the database I would like to ask them
for a username and password and then check the table to
see if these are correct. Can someone help me do this.
Thanks.

Before you spend too much time on this you do know that any user with even
a smattering of knowledge on how Access works will be able to simply link
to your table and read all of the passwords and user names right?

The built in user-level security (while hackable as well) is the only way
to do something like this and have any barrier affect whatsoever.

 

[stuck]

Yes I know that. But these are people with no knowledge
of access at all. All they are doing is entering data. I
just want to make sure that only people I train beforehand
will have access to the database.