Help with my site

[hsuballer42]

me and a friend are currently building a site that is underconstrutction. We dont want the site to be a open site where people can roam through it at will. we want people to have to register and use a login name so we can keep up with who is active with the site. We are having a hard time finding the software to make this possible. We heard that we could use micfrosoft access as our database....we aernt sure how that would work. If you have any suggestions or sites in which we can find this addon for our site it would be deeply appreciated. If you know of any good freeware that would be nice to....

to make it simpler..what is it i need to do to make people have to register and then login and out of my site? Is there anything special i need to download or what? please help..

[lmf232s]

you could do this with a text file or a Database.
I would use a database.
Create a table.
Make your fields be things you want to capture about the user like
UserID
Password
Email
IP address
Etc.

Now when they sign up you will save that information to the database.
Now when the user goes to log in, lets say they have to enter UserID
and password.

Then this should help you retrieve the user information and validate it

SQL = " Select userid, password from user where userid = '" & txtUserID & "' and password = '" & txtPassword & "'"
objRS.Open SQL, objConn
If objRS.EOF then
' there was no match, do not let user log in
' maybe rediret them to a regestration page
else
' user was validated
' maybe set a session variable, validate every page against this session variable, you could even set a cookie which is what most sites do
end if

[stevem2004]

You can download all the necessary files for Database login page from WebWiz Guide http://www.webwizguide.com/asp/sample_scripts/database_login_script.asp

[lmf232s]

stevem2004,
nice site, I like that.

[Bullschmidt]

And here's something short and simple about the login concept I like to use which hopefully may give you some ideas (although users don't actually register themselves with this):

Classic ASP Design Tips - Login Page
http://www.bullschmidt.com/devtip-loginpage.asp