Hi

I am having the following error



Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.




while i try to update my table. I am using Access as backend. code i am using is


VB Code:
  1. <html>

  2.  
  3. <head>

  4. <title>New Page 2</title>

  5. </head>

  6.  
  7. <body topmargin="0" leftmargin="0">

  8. <!!--#include virtual="/adovbs.inc"-->

  9. <%

  10. Dim objConn

  11. Dim counter ' TO COUNT RETURNED RECORDS

  12. counter = 0

  13. curDir = Server.MapPath("misc/db1.mdb")

  14. set objconn = Server.CreateObject("ADODB.Connection")

  15. set objrs = Server.CreateObject("ADODB.Recordset")

  16.  
  17.  
  18.  
  19. Response.write curDir

  20. objconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & curDir

  21. objrs.cursorLocation = 3

  22. objrs.CursorType = 2

  23. objrs.LockType = 4

  24. ss="update guest set Name='gg' where sno=3"

  25.  
  26.  
  27. objconn.execute ss

  28.  
  29.  

  30.  
  31.  
  32. Response.write curDir

  33. Response.write"<br>"

  34. Response.write objconn

  35. Response.write"<br>"

  36. objConn.Close

  37.  
  38. %>

  39. </body>

  40. </html>










please help as i have been tring this for last two days is very much upset about this