How to get values from a access database?

[kruxty]

i want to make a login page with user and password.
But i want that this values will be fetch in a access DB.
How can i get values from a DB?
I already have the page with the user and password fields, just need the syntax to link with the DB!
All help... Tkx

 

[baddos]

Try checking out this FAQ.

faq333-1030

 

[amorous]

Something like this:

<%

Dim Conn,rs,strsql

Set rsName = Server.CreateObject("ADODB.Recordset")
Set MdConnection = Server.CreateObject("ADODB.Connection")

conn.Open strConnect

'strconnect is the connection string to your database...

strsql = "SELECT Username, Password FROM Login WHERE Username = '" & _ 
Request.Form("txtusername") & "' and Password = '" & _
Request.Form("txtpassword") & "'"

set rs = conn.Execute (strsql)

If (not rs.BOF) and (not rs.EOF) then
   Response.Redirect "logincorrect.asp"
else
   Response.Redirect "accessdenied.htm"
end if


'close the recordset
rsName.close
set rsName = nothing

'close the connection
conn.close
set conn = nothing

%>

-VJ

 

[Eek]

Check out :

http://www.webwizguide.com/asp/tutorials/connecting_to_a_database.asp

a simple tutorial for ASP and database