sir,

Thank you in advance. I have a problem. With ASP codes I can read the fields from an Access File. But when i try to update the fields or Add New Record it shows an error
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/NewAdmdone.asp, line 20

Kindly help me.


<html> <body bgcolor="33aa99">
<form>

<% n1=request(trim("n1"))
n2=request(trim("n2"))
n3=request(trim("n3"))
n4=request(trim("n4"))
n5=request(trim("n5"))
n6=request(trim("n6"))
n7=request(trim("n7"))
n8=request(trim("n8"))
n9=request(trim("n9"))

dim sd
dim rs
Set sd = Server.CreateObject("ADODB.Connection")
sd.ConnectionString="Provider=Microsoft.Jet.OLEDB. 4.0;Data Source="&_
Server.MapPath ("/logon.mdb") & ";"
sd.Open
rs.open "insert into students (AdmNo,DOB,SName,Clas,Sec,FName,MName,Adrs,Phone)" &_
"values("&n1&",'"&n2&"','"&n9&"',"&n3&",'"&n4&"',' "&n5&"','"&n6&"','"&n7&"','"&n8&"')"%>
</center>
<% rs.close
sd.close
%>
<center> !Inserted Successfully!
<a href="heading.asp"> <h3> Home</a></center>

</form></body> </html>