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

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.

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