Hi, 1. Please excuse my English mistakes I am a Swiss with Swiss German as mother language. My problem is related to using MySQL under Windows98 I have installed MySQL 3.23.41 MyODBC 2.50.38-win95 and Microsoft ADO 2.0 is used. I often get an error -2147217887 when a string in a VARCHAR- or a TEXT-field should get replaced by a longer string (of course still within the VARCHAR-length specification which means the replacement can not be done. A work around is to always enlarge with spaces to a maximum length but it s not really what we are looking for and its a problem regarding data which has been imported from an Access database and therefore dos not have the spaces. The error occurs when the content of the recordset field should get replaced (before the update command) I have always had the error when TEXT fields are concerned in the case of VARCHAR-fields it happens in some cases and others behave perfectly. I do not see any bug from my side which could be the reason. Can someone help me with information about this? Many thanks Alain Bebie [EMAIL PROTECTED] --------------------------------------------------------------------- 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