In my previous post Working with databases (OleDb, MS Access 2007) code-wise (SELECT COMMAND) I’ve made a small introduction regarding this matter, so I won’t bother doing the same here.
In order to execute UPDATE, INSERT OR DELETE statements against our database, we pretty much need the same objects as we did for retrieving data from a database:
- A database connection
- A SQL command
We’ll start off again by declaring the objects we need: