Yes, I have read the manual, many times, and searched the archives. I am using an ODBCDirect (in MS Access 97) workspace to connect to the MySQL server. That works fine, and I can get and display data. I can even execute a recordset.edit command, but when I do recordset.update, I get ODBC call failed, and the MySQL log shows it was sent this query: update senators SET abbr='smi' , first_name='Bob' , last_name='Smith' , email_address=NULL where current of NO_NAME I have "Return matching rows" set in the ODBC driver options. I have opened the record set with dbOpenDynaset and dbOpenDynamic and get the same error both times. I know MySQL doesn't support cursors, but why is Access trying to update the row with that funky name? I have both a unique ID and last modification time stamp in the table, and select both of them when I open the recordset. If this would be better taken to the MyODBC list, you can refer it there. Thanks for your help. j----- k----- -- Joshua Kugler Associated Students of the University of Alaska Fairbanks Information Services Director [EMAIL PROTECTED] 907-474-7601 --------------------------------------------------------------------- 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
