Databases - Using DAO
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.
Types of Recordset
There are several types of recordset that you can create, and which one you choose depends on several things. You will meet four difference types when using the MS Jet engine:
- Table-type Recordset - this type is formed from fields from only one table. You can add, change and delete records, and this is reflected in the actual database. Movement is unrestricted.
- Dynaset-type Recordset - this type can be made up from more than one table, and is editable, as the table type. Movement is unrestricted. If you are only accessing one table, use the table type recordset.
- Snapshot-type Recordset - this is a static copy of the original database data. It can be from multiple tables, but none of the original data will be updated. Movement is unrestricted.
- Forward-only-type Recordset - this is identical to the snapshot type, except that movement is restricted to moving forwards only. 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.
Page 1 of 3