Updating a recordset in msaccess 2016
The last of these gives I/O access to data stored on a local machine.In the next couple of tutorials I will be exploring each of these objects in greater detail, providing concrete and full examples of their usage.You may also notice the Record object’s intimate association with the recordset object.As you can see from the above diagram, the recordset object exposes a Fields collection with a number of fields. The Rating field will be updated for each sales person based on their Sales YTD value.
Next, construct code in a VBA Module to generate the recordset with DAO objects and loop through it. The Properties collection related to the Connection revealed a great deal of information on the connection for the source used.