Cannot update, database or object is read only

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sweetjos
    New Member
    • Mar 2010
    • 10

    Cannot update, database or object is read only

    Thank you sir,
    I have another question....

    Recently I got this error.
    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
    /Jose/add.asp, line 21

    Browser Type:
    Opera/9.80 (Windows NT 5.1; U; en) Presto/2.5.22 Version/10.50

    Page:
    GET /Jose/add.asp
    My code is as follows.....
    Code:
    <%@ Language=VBScript %>
    <% Response.Buffer = true %>
    <HTML>
    <HEAD>
    <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
    </HEAD>
    <BODY>
    <%
    Dim rs 
    
    Set rs = Server.CreateObject ("ADODB.Recordset")
    rs.CursorType = 2
    rs.LockType = 3
    rs.Open "register", "DSN=Registration"
    
    
    rs.AddNew 
    
    rs("Name") = Request.Form ("name")
    rs("Age") = Request.Form ("age")
    rs.Update 
    
    
    rs.Close 
    set rs = nothing
    Response.write("Updated")
    %>
    <P>&nbsp;</P>
    
    </BODY>
    </HTML>
    Last edited by jhardman; Mar 12 '10, 10:14 PM. Reason: put code in code tags. PLEASE use code tags on all future posts with code. Faliure to do so could make me delete your post
  • jhardman
    Recognized Expert Specialist
    • Jan 2007
    • 3405

    #2
    I notice you don't specify login credentials, many dbs require a login in order to update, although a public connection can often read data. If it were me, I would create a user for this function, make sure he has access to update the data, and make sure you connect as that user.

    Jared

    Comment

    Working...