http://www.onlinepclearning.com
In this tutorial I will demonstrate how you can both append (update) and delete a record in MS Access from an Excel Userform.
1. Appending data in our MS Access database from MS Excel with ADODB from a Userform
2. Delete a record in Access from Excel with ADODB from a Userform