hello all, I use ADO to connect to mysql database. I get an ADO recordset to show datas and update the modified records with SQL statement. So I shall resync the recordset and the database myself. But when I call the method Resync I get an error which code is 80004005 and the meaning is such as "don't support this interface". I set properties of the ADO recordset like that: CursorLocation = adUseClient; CursorType = adOpenStatic; LockType = adLockBatchOptimistic; Thanks! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php