how to save to a access database.

here is what im trying to do on the testsubmit.asp example.



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>
   <HEAD>
      <TITLE>FCKeditor - Posted Data</TITLE>
      <STYLE TYPE="text/css">
         body, td 
         {
            FONT-SIZE: 12px; 
            FONT-FAMILY: Arial, Verdana, Sans-Serif;
         }
      </STYLE>
   </HEAD>
   <BODY>
      <table width="100%" border="1" cellspacing="0" bordercolor="#999999">
         <tr style="FONT-WEIGHT: bold; COLOR: #dddddd; BACKGROUND-COLOR: #999999">
            <td>Field</td>
            <td>Value</td>
         </tr>
         <%
         For Each sForm in Request.Form
         field1 = sForm
         content = Server.HTMLEncode( Request.Form(sForm) )
           'pagename = replace(Request.Form("pagename"), "'", "''") 


         %>
         <tr>
            <td valign="top" nowrap><b><%=field1%></b></td>
            <td width="100%"><%=content%></td>
         </tr>
<%
  id = Request.querystring("id")

  dim query
  if id then  'UPDATE a page
    query = "UPDATE tblpages SET content = '" & content & "' WHERE ID = " & id
  else
    query = "INSERT INTO tblpages (content) VALUES ('" & content & "')"
  end if

  dim conn
  set conn = getConn()
  conn.execute(query)
  conn.close()
  set conn = nothing
  response.redirect("../../master.asp")         
Next
         %>
      </table>
   </BODY>
</HTML>

Fri, 12/05/2003 - 06:51

fruitbatinshade

Joined: 31/12/2003

Posts: 10

RE: how to save to a access database.

This is a problem with access not the editor. I'm guessing your using ASP and not ASP.Net Have a search on msdn.microsoft.com for 'Operation must use an updateable query' because the code looks ok to me.

Mon, 12/29/2003 - 02:29

jyrx

Joined: 29/12/2003

Posts: 1

RE: how to save to a access database.

"Operation must use an updateable query" usually means that the database or the folder in which it resides is write protected (or rather that the IUSR_<your computer name> account is not permitted to write or change the file/folder).

Set your permissions, and it should work just fine.

Mon, 12/29/2003 - 07:40

runprn

Joined: 05/09/2003

Posts: 17

RE: how to save to a access database.

Right - To further clarify, you need to set the database folder permissions to allow the IUSR and anonymous internet guest user, not to mention local objects. Be sure they have write permissions to both the folder and the db, itself.