rs.delete won't fly

[joe speigle]

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