Probem with updating a record in access database

Results 1 to 2 of 2

Thread: Probem with updating a record in access database

  1. #1
    Join Date
    Dec 1969

    Default Probem with updating a record in access database

    hi, i am connecting to my database by the following statment. i am trying to update my table and it is giving the below error message. can someone tell me what is my problem. thank you for the help <BR><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"&id&"&#039"<BR> mySQL,conntemp<BR> <BR>recset.Fields("FName").Value="mo"<BR>recset.Up date <BR> <BR>recset.Close<BR>set recset=nothing <BR>conntemp.Close <BR>set conntemp=nothing<BR><BR>i am getting this error message.<BR><BR><BR>ADODB.Field error &#039 800a0cb3&#039 <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>/alterprof.asp, line 49 <BR><BR>line 49 is recset.Fields("ID").Value="mo"<BR><BR>

  2. #2
    Sumithra Gopalan Guest

    Default RE: Probem with updating a record in access databa

    Try this,<BR><BR>myDSN="DSN=inforeq;uid=student"<BR>di m recset<BR>set conntemp = server.createobject("ADODB.connection")<BR>conntem "inforeq"<BR>set recset = server.CreateObject("ADODB.Recordset")<BR>dim mySQL<BR>mySQL="select * from table1 where ID=&#039"&id&"&#039"<BR> mySQL,conntemp<BR>recset("FName")="mo"<BR>recset.U pdate <BR>recset.Close<BR>set recset=nothing <BR>conntemp.Close <BR>set conntemp=nothing<BR><BR>HTH

Posting Permissions

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