now when I run this page it says that
• “Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/address/UploadReceive.asp, line 99
actually it gives the error in sid=rs.fields(“sid”).value, I will be thankful if somebody help me out.
code is given below
Bye


<% Dim Conn, RS,DSNName,sid
Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("database/AddressBook.mdb")
Conn.Open DSNName

rs.open"select max(sid) from users",Conn,3,3
 sid=rs.fields(“sid”).value
  rs.close
%>





Zaeem Sherazi

__________________
Zaeem Sherazi

Hi Zaeem,
Your query will be returning a field called "max(sid)" or similar, try changing it to:
HTH,

Chris