I am just wondering whether I could use update_recordset to update a value for a single record. Microsoft has used update_recordset where there are lot of records needs to be updated. But is there any downsides we will be having if we use the same for a single record updation? Is there any reason for us to user the update method in this scenario?
Also, I wanna understand whether update_Recordset will process anything different when compared to normal update method since it as well hits the table's update method unless the table methods is been forced to not to be called.
Thanks in advance.