"Operation must use an updateable query. " Help ne

Results 1 to 2 of 2

Thread: "Operation must use an updateable query. " Help ne

  1. #1
    nath Guest

    Default "Operation must use an updateable query. " Help ne

    &#039I am trying to insert a record into Access database. It gives an error. Not sure why so.<BR>could some one give me some idea pls?<BR> <BR>set conn = server.createobject <BR>application("strConnection") = "driver={Microsoft Access Driver *.mdb)};DBQ=C:inetpubWWWrootmembers.mdb"<BR>conn.O pen application("strConnection")<BR><BR>conn.Execute "insert into Users (Title, Firstname, " _<BR>& "Password) values (" _<BR>& "&#039" & Request.Form("Title") & "&#039, " _<BR>& "&#039" & Request.Form("FirstName") & "&#039, " _<BR>& "&#039" & Request.Form("VPassword") &"&#039)" Response.Redirect "./test.asp"<BR><BR>Error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <BR><BR>/signin.asp, line 43 <BR>

  2. #2
    geeoff Guest

    Default RE:

    Is there a unique key in this table? It sounds like you may be trying to insert values that already exist in the table. So it is telling you that you need to update those values with the new info. Although if there is a unique key, this should give you an key violation error. If there isn&#039t then it should enter an identical row.<BR><BR>HTH,<BR><BR>geeoff

Posting Permissions

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