Updateable query error !

Results 1 to 3 of 3

Thread: Updateable query error !

  1. #1
    yashioki Guest

    Default Updateable query error !

    Get this error on a page, that work just fine at home in PWS:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error 80004005 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. <BR><BR>/stalskog/engelska/nyheen1u.asp, line 37 <BR><BR>What&#039s wrong here, I have no idea ???<BR>The code, the errorcode is refering to is this:<BR><BR>SQL_ENYHEADD = "INSERT INTO nyhe_en(rubrik, stycke, bild) VALUES(&#039" & rubrik & "&#039, &#039" & stycke & "&#039, &#039" & bild & "&#039);"<BR><BR>enyheConn.Execute(SQL_ENYHEAD D) (THIS IS LINE 37 !!!)<BR><BR>enyheConn.Close<BR><BR>Any help will be much appriciated !<BR>/303<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Updateable query error !

    Are you opening a connection object...as in check if the object is open with ConnectionObjectName.state

  3. #3
    yashioki Guest

    Default RE: Updateable query error !

    The Object is open, and as I said, apart from the DNS-less conection part the code is exactly the same as one that worked at home on PWS (not a misstake). Connecting to the databse also worked fine, but all pages recive the same error when trying to update, or write to a db.<BR><BR>/303

Posting Permissions

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