1) What video are you referring to? I will need some more details.
2) No there is no sample to demonstrate the user confirm page. It uses a lookup recordset to look up the random string and the user id from the querystring variables in the link, and uses that to trigger an update on the users table.
3) recporset is a misspelling of recordset, it is a typo.