Thanks - I have just tried db.cursorlocation = aduseclient and attempted to update an edited record and now on rs.update I get the error I was getting for the delete!!!
-2147467259 [Microsoft][ODBC Visual FoxPro Driver]SQL: Statement too long.
Thanks again