Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Feb 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cant work in another pc

    Hi,
    I'm currently develop an inventory system.After i had tested the system in my own pc with no error but I had received 2 error message when i moved to another pc. I"m using ASP language as my system with the Macromedia Dreamweaver. Two types of the error is :

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
    /andrew/reservation/reserveform.asp, line 109


    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Could not delete from specified tables.

    What does is means by "Operation must use an updateable query"??I"m looking for someone to help me to solve this problem.
    Thanks.

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Usually has to do with permissions, take a look at the following article:
    http://support.microsoft.com/kb/q175168/

    Good luck;

  • #3
    New to the CF scene
    Join Date
    Feb 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    seems like nothing wrong with my coding

    Thanks for your reply. I had visited to "http://support.microsoft.com/kb/q175168/" but my coding seems like nothing wrong with it.

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
    /chew/login/changecontent.asp, line 69

    <%
    Dim rstSearch
    Dim strSQL
    Dim strAction
    Dim strMemberid
    Dim strOldpassword
    Dim strNewpassword1
    Dim strNewpassword2
    Dim strPassword
    %>

    <!--#include file="../lib/dbconnection.asp"-->

    <%
    strMemberid = Session("memberid")
    strOldpassword = Request.form("oldpassword")
    strNewpassword1 = Request.form("newpassword1")
    strNewpassword2 = Request.form("newpassword2")
    strAction = Request.Form("action")

    If Session("memberid") = "" Then
    Response.redirect "../login/default.asp"
    End If
    %>

    <html>

    <head>
    <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
    <meta name="ProgId" content="FrontPage.Editor.Document">
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
    <title>Change Password Page</title>
    </head>
    <%
    If strAction = "Home" Then
    If session("membertype") <> "" Then
    If Session("membertype") = "admin" Or Session("membertype") = "manager" Then
    Response.redirect"../menu/adminmanright.asp"
    Else
    If Session("membertype") = "supervisor" Then
    Response.redirect"../menu/supervisorright.asp"
    Else
    If Session("membertype") = "sales supervisor" Then
    Response.redirect"../menu/salesright.asp"
    End If
    End If
    End If
    End If
    End If

    %>

    <body>
    <%
    strSQL = "SELECT * FROM login WHERE memberid = '" & strMemberid & "'"
    Set rstSearch = cnnSearch.Execute(strSQL)

    strPassword = rstSearch.Fields("password").Value

    If strAction = "Submit" Then
    If strOldpassword <> "" And strNewpassword1 <> "" And strNewpassword2 <> "" Then
    If strOldpassword <> strPassword Then
    Response.redirect "invalidcontent.asp"
    Else
    If strNewpassword1 <> strNewpassword2 Then
    Response.redirect "invalidcontent.asp"
    Else
    strSQL="UPDATE login SET password = '" & strNewpassword1 & "' WHERE memberid = '" & strMemberid & "'"
    cnnSearch.Execute(strSQL) 69
    Response.redirect "successchange.asp"
    End If
    End If
    Else
    Response.Write("<center><font face='Arial' color=#ff0000><b>Please Fill In The Blank...</b></font></center>")
    End If
    End If

    %>

    <form name='changepassword' method='post' target='_self'>
    <br><br>
    <center><h1><font face='Arial' size='5'>Please change your password</font></h1></center>
    <br><br>

    <center> <table border=0>
    <tr>
    <td align='right'><font face='Arial' size='4'>Member ID : </font></td>
    <td><input type='text' value= <%=strMemberid%> size='20' name='memberid'></input></td>
    </tr>
    <tr>
    <td align='right'><font face='Arial' size='4'>Old Password : </font></td>
    <td><input type=password size='20' name='oldpassword'></input></td>
    </tr>
    <tr>
    <td align='right'><font face='Arial' size='4'>New Password : </font></td>
    <td><input type='password' size='20' name='newpassword1'></input></td>
    </tr>
    <tr>
    <td align='right'><font face='Arial' size='4'>Confirm New Password : </font></td>
    <td><input type='password' size='20' name='newpassword2'></input></td>
    </tr>
    <tr>
    <td align='right'></td>
    <td><input type='submit' value='Submit' name='action'></input>
    <input type='reset' value='Reset'></input></td>
    </tr>
    </table></center>

    <br><br><br>

    <center>
    <p><input type='submit' name='action' value='Home'></input></p>
    </center>
    </form>
    <!--#include file="../lib/footer.asp"-->
    </body>

    </html>

  • #4
    New Coder
    Join Date
    Apr 2004
    Location
    Columbus, Ohio
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    That is correct, usually the coding is not the problem with that it is in your IIS settings.

    Your database file is in a certain directory. Usually called /db/ or something like that. If you have the ability to chage the "RIGHTS MANAGEMENT" it can be in any directory you would like.

    Usually your Hosting provider can assist you with that. You database must have READ/WRITE permissions on it

    By default when you upload a file to the server all files have READ ONLY attributes you must specify which files you would like to have READ & WRITE attributes.

    Hope that helps
    Hate something?
    Tell us about it
    Go Complain


  •  

    Posting Permissions

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