text: It appears your recordset is not the updateable type.  The standard syntax might be:\n\nMyRst.Open MySQLSyntax, MyConnection, option 1, option 2\n\nThe option 1 and 2 are where you set the recordset type - for your operation you would want dynamic and optimistic locking.\n\nIn addition, you usually need to tell the recordset you are adding first, like this:\n\nMyRst.AddNew\n\nOtherwise the Update method won't work.\n\nHope these ideas help.