The default locktype for a recordset is adLockReadonly, and as such you
cannot modify the recordset's contents. See
www.vbmysql.com/articles/cursorsandlocks.html
You need rst.Open strSelect, conn, adOpenStatic, adLockOptimistic
Regards,
Mike Hillyer
www.vbmysql.com
> -----Original Message-----
> From: joe speigle [mailto:joeofclew@stripped]
> Sent: Wednesday, July 02, 2003 3:09 PM
> To: myodbc@stripped
> Subject: rs.delete won't fly
>
>
> hi list,
>
> I have to post this one.
>
> I can't get it to delete. Perhaps somebody can tell me
> quickly what's the
> reason I get the error "object or provider is not capable of
> performing
> requested operation". I am using access 2000 with myODBC
>
> "DRIVER={MySQL ODBC 3.51 Driver};" & _
> "SERVER=www.hovercr.com;" & _
> " DATABASE=apres;" & _
> "UID=foo;PWD=fah; OPTION=3"
>
>
> vbscript code for the ado is:
>
>
> Dim rst As ADODB.Recordset
> Dim conn As ADODB.Connection
> Set rst = New ADODB.Recordset
> Dim strSelect As String
> Set conn = New ADODB.Connection
> conn.ConnectionString = connString()
> conn.Open
> strSelect = "select * from client where client_id = '" &
> Me!txtClientId & "'"
> MsgBox "strSelect = " & strSelect
> rst.Open strSelect, conn
> rst.Delete
>
> thanks,
> this is my first post, I downloaded the myODBC last night to put the
> tables on they mysql off the access.
>
> joe
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?> unsub=mhillyer@stripped
>
>
