Can't update foxpro table from VB6 through ADO

[Damby]

I am trying to update a foxpro "loose" table from VB6 through ADO. Here is how:

Set rstProduiAvan = CreateObject("ADODB.Recordset&quot

rstProduiAvan.CursorType = adOpenStatic
rstProduiAvan.LockType = adLockOptimistic
rstProduiAvan.CursorLocation = adUseClient

rstProduiAvan.Open "SELECT * FROM produi", cnnProdui

rstProduiAvan.MoveLast
szChaineRecherche = "PChamp3 = '" + rst!Pro_Id + "'"
rstProduiAvan.Find szChaineRecherche, 0, adSearchBackward
rstProduiAvan!PPROREMPL = szCleManu
rstProduiAvan.Update

I just can't get Ado to update the table. I keep getting a message stating that the Instruction is too long (error -2147467258 (80004005))

I tried to do it many other ways but it never works. If I try other other operations like queries, everything works fine. My problem is when I try to update the table.

Some helps would be welcome.