I am having a problem with IIS 3 and edit updating.<BR><BR>When I edit a record using ASP on a NT server running IIS 3 I get the<BR>following error:<BR><BR>Error in Update (3219)Invalid operation.<BR><BR>I can add records fine and even delete them but can&#039t change them.<BR><BR>I have access to another server running IIS 4 and the process works fine,<BR>unfortunately my IIS4 server is running on a slow connecting via my office<BR>so cannot run my site from there.<BR><BR>My site is with a hosting company who I have been nagging to change to IIS<BR>4 - they say they will soon but so far I am stuck - any suggestions?<BR><BR>I wondered if it was that the ASP code I am using is IIS4 specific so have<BR>listed it below in case anyone in the know could advise me how I could<BR>change it to run on IIS3?<BR><BR>I am fairly new to ASP - I can&#039t imagine it is a server permission issue? I<BR>can delete so shouldn&#039t I be able to edit?<BR><BR>I&#039ve tried locating information on IIS3 v IIS4 to locate a coding issue but<BR>can&#039t find anything on the net.<BR><BR>Any help would be most apreciated.<BR><BR><BR>Charles<BR><BR><BR>&#060;%< BR>&#039 &#039&#039&#039&#039&#039&#039&#039&#039&#039&#039 &#039&#039&#039&#039&#039&#039&#039&#039&#039&#039 &#039&#039&#039<BR>&#039 This is the leading Logic for the Edit screens<BR>&#039&#039&#039&#039&#039&#039&#039&#03 9&#039&#039&#039&#039&#039&#039&#039&#039&#039&#03 9&#039&#039&#039&#039&#039&#039&#039&#039&#039&#03 9&#039<BR>on error resume next<BR>Session(LOCAL_SESS_ID & "MODE") = ""<BR>SQL_RETURN_FIELDS ="*"<BR> SQLString = "SELECT " & SQL_RETURN_FIELDS & " FROM " & SQL_TABLE & " WHERE<BR>((Ref=" & request.form("Ref") & "));"<BR><BR>&#039 LOAD RECORDSET<BR> Set rs = Server.CreateObject("ADODB.Recordset")<BR> rs.Open SQLString, conn, 1, 2<BR><BR><BR> for each fld in Request.form<BR> myField = request.form(fld)<BR> if trim(myField)="" then myField = " "<BR> if myField&#060;>Ref and myField&#060;>Enhanced and myField&#060;>Verified then rs(fld) =<BR>myField<BR> next<BR><BR> rs.update<BR> rs.close<BR> if err.number>0 then<BR> ShowSorry "Error in Update (" & cstr(err.number) & ")" & err.description<BR> else<BR> response.redirect(BASENAME & "?mode=EDIT_DONE")<BR> end if<BR>&#037;&#062;<BR><BR><BR>pls cc responses to charles@micromax.co.uk<BR><BR><BR><BR><BR><BR><BR> <BR><BR>