User Login form

[Guest]

Hi Guys
I want to create a user login form for my Database, one that appears before
the database opens and users have to sign in with their username being their
country and then they have to put in passwords. I have a table in the database
tblCountry_Passwords which has fields CountryId, Country, Password. I want
the countries to be a drop down list on the form. If someone does not enter a
password and tries to login there must be a "enter password" message. If
someone enters wrong password 3 times then the database should log them out.
I am not a programmer so please help me.
Thank you

 

[Arvin Meyer [MVP]]

Will all users from the same country share the same password? If so, you
might wish to reconsider your design since it is rarely a good idea for
users to share a password. I would add a username separately from the
country, or consider using only the country without a password to get in.
Also, while you can hide any database functionality, in order to run the
code, you need to have the database open. None of those ideas are as secure
as User-Level Security, which does intercept the database opening, but does
require a standard username and password to be typed in.

 

[Guest]

The country is sort of the username. Only one person in each country would
have access to this database which will be on global server. So the person in
Argentina needs to type Argentina as username and then password as a Person
in Jamaica will type Jamaica and their password.