Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Talking Unanswered: Error table ......READ ONLY

    I have a problem, I want to update the registries of a table and it leaves an error to me that the table is of READ ONLY, because.
    My DDBB this a Red Hat 9 linux, and ne my clients Win98 gives that error, hize me the test with servidoes Windows Xp and all this Ok.
    consulta = "UPDATE "Update certif_bauts Set name = '" & Trim(txtname.Text) & "'"
    Set conn = New ADODB.Connection
    conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
    & "SERVER=" & Trim(cServer) _
    & ";DATABASE=" & Trim(cDatab) _
    & ";UID=" & Trim(cUser) _
    & ";PWD=" & Trim(cPass) _
    & ";OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384
    conn.CursorLocation = adUseClient
    conn.Open
    Set rs = New ADODB.Recordset
    rs.Open consulta, conn, adOpenKeyset, adLockOptimistic

    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    What user privileges do you have for that table? Sounds like you need to have privileges increased so you can do more than select data.

  3. #3
    Join Date
    Mar 2004
    Posts
    6

    Exclamation

    User whereupon entrance have all the privileges. Since with this user also I add and I eliminate single it cannot update the registos.

Posting Permissions

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