Jump to content

sunilkumarpt

Members
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

 Content Type 

Posts posted by sunilkumarpt

    need serious help on asp and ms access

    in ASP

    Posted

    I'm having serious problems trying to insert data into a ms access database.  everytime i submit the data, they don't get inserted into my ms access table.  I think I don't have permission to insert data into the ms access table, but I don't know how to change the settings so that I can just simple insert data into my table.  Any help as to the step-by-step procedure to solve my problem will be received with great thankshere's the code.  the actual form part is from another asp page.  This page does the actual inserting of data into table:<%set conn=Server.CreateObject("ADODB.Connection")conn.Open "Forum"set rs=Server.CreateObject("ADODB.recordset")%><html><body><%sql="INSERT INTO forum1 (PosterName,Date,Comments,"sql=sql & " VALUES "sql=sql & "('" & Request.Form("name") & "',"sql=sql & "('" & Request.Form("date") & "',"sql=sql & "'" & Request.Form("comment") & "')"on error resume nextconn.Execute sql,recaffectedif err<>0 then  Response.Write("No update permissions!")else   Response.Write("<h3>" & recaffected & " record added</h3>")end ifconn.close%></body></html>

    <%set rs=Server.CreateObject("ADODB.Connection")rs.Open "Forum"%><html><body><%rs("posterName")=Request.Form("Name")rs("Date")=Request.Form("date")rs("Comments")=Request.Form("comment")rs.updateconn.close%></body></html>

    add record to table

    in ASP

    Posted

    firt u check ur security permission then try below code<%set conn=Server.CreateObject("ADODB.Connection")conn.Open "Forum"%><html><body><%conn("PosterName")=Request.Form("Name")conn("date")=Request.Form("date")conn("comments")=Request.form("comment")conn.updateconn.close%></body></html>

    add record to table

    in ASP

    Posted

    I'm having this same problem, I can't insert any records into my access database.  I keep gertting referred to the no update permissions page alternative.  I was wondering whether you could help me.  Do you have any experience in using MS access 2002?  here is my code:<%set conn=Server.CreateObject("ADODB.Connection")conn.Open "Forum"set rs=Server.CreateObject("ADODB.recordset")%><html><body><%sql="INSERT INTO forum1 (PosterName,Date,Comments,"sql=sql & " VALUES "sql=sql & "('" & Request.Form("name") & "',"sql=sql & "('" & Request.Form("date") & "',"sql=sql & "'" & Request.Form("comment") & "');"on error resume nextconn.Execute sql,recAffectedif err<>0 then  Response.Write("No update permissions!")else   Response.Write("<h3>" & recAffected & " record added</h3>")end ifconn.close%></body></html>

    firt u check ur security permission then try below code<%set conn=Server.CreateObject("ADODB.Connection")conn.Open "Forum"set rs=Server.CreateObject("ADODB.recordset")%><html><body><%rs("PosterName")=Request.Form("Name")rs("date")=Request.Form("date")rs("comments")=Request.form("comment")rs.updateconn.close%></body></html>
×
×
  • Create New...