Cmne Nk Buat Login Page Dlm Acces?

[ape_ape_aje 0]

Saya kat sini nk mintak idea n pendapat brkenaan cmne kite nk buat log in page mggunakan access ye? lebih kurang macam sistem lain la...perlu ade autorized user nk guna sistem....plsss.....help me...dh lama tinggal eccess nih....nk buat small sistem utk staff admin kat ofis

[Nazirul 0]

ko guna programming apo ni...

ni cth aku buat guna ASP & ADODB.Konecsyen .. erkk

<% @language ="javascript" %>
<%
if (Request("submitName")== "Login"){

var DSN = "DSN=database";
var Conn = Server.CreateObject("ADODB.Connection");
Conn.Open(DSN);

rs = Server.CreateObject("ADODB.Recordset");

sql = "SELECT * FROM login WHERE " + "username='" + Request("userLogin") + "' AND " + "password='" + Request("userPassword") + "'";

rs.Open(sql,Conn);

if (rs.EOF){
rs.Close();
rs = null;
Conn.Close();
Conn = null;

Response.Redirect("relogin.asp");
}

else{
rs.Close();
rs = null;
Conn.Close();
Conn = null;
Session("sesi") = "OK";
Response.Redirect("/pharmacy/user/userIndex.asp");

}
}
else{

%>

========

var DSN = "DSN=database";

========

yang tu ko set kat administrator tu... nama database aku ialah 'database.mdb

ps: aku silap ke ni? ker system ko fully access.. ops sorii