'This sub-procedure loops through all current In the immediate window execute the function by entering testDAO and pressing the return key. Open a new module and enter the following code. As standard, the DAO library is already referenced in Access whilst the ADO library is not. In order to use recordsets, we need to reference certain libraries. They both have similar functions and similar operation speeds (DAO is a bit faster) but as a general rule use DAO if you are referencing standard Access tables within your database and use ADODB when you are referencing tables held outside of your Access application (SQL Server for instance). There are two types of recordsets, DAO and ADODB. With recordsets, we can truly interact with the data stored in our databases. Recordsets enable us to reference field names, search for records, filter records, count records and much more. When we open a recordset, the recordset itself is stored in memory and we are able to loop through the records one at a time, manipulating the data as we go. So, what is a recordset? You can think of a recordset as a table or query that we can utilise (read, update, delete, insert) but cannot see.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |