We saw last time how to use the data control to display and edit records in a database. This week, we will look at how to achieve the same results by using the built in database commands. There are several types of recordset that you can create, and which one you choose depends on several things. You can add, change and delete records, and this is reflected in the actual database. Movement is unrestricted.
Movement is unrestricted.
If you are only accessing one table, use the table type recordset. It can be from multiple tables, but none of the original data will be updated. Movement is unrestricted. This is useful if you want to make just one pass, for example in report creating. This type can be set as a property of the data control, or when the RecordSet is opened using OpenRecordSet.