problem with updating a record in access

Results 1 to 2 of 2

Thread: problem with updating a record in access

  1. #1
    Join Date
    Dec 1969

    Default problem with updating a record in access

    hi, can someone tell why this is not working. i am trying to update a record in the table. I am getting the following error:<BR>ADODB.Field error &#039 800a0cb3&#039 <BR>The operation requested by the application is not supported by the provider. <BR>thank u for ur help.<BR><BR>&#060;%<BR> id1 = Request.QueryString("id")<BR> newid = Request.QueryString("newid")<BR> &#039CONNECTION TO DATABASE START HERE<BR> myDSN="DSN=inforeq;uid=student"<BR> dim recset<BR> set conntemp = server.createobject("ADODB.connection")<BR> "inforeq"<BR> set recset = server.CreateObject("ADODB.Recordset")<BR> dim mySQL<BR> mySQL="select * from table1 where ID=&#039"&id1&"&#039"<BR> mySQL,conntemp<BR>recset("ID")=newid <BR>recset.update

  2. #2
    karimi Guest

    Default RE: problem with updating a record in access

    try this:<BR>set conntemp = server.createobject("ADODB.connection")<BR>conntem "data source=inforeq", "student"<BR><BR>set recset = server.CreateObject("ADODB.Recordset")<BR><BR>mySQ L="select * from table1 where ID=&#039"&id1&"&#039"<BR>set recset = conntemp.execute(mySQl)<BR>....<BR>....<BR><BR><BR >

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts