لطفا منتظر باشید ...
Summary
In this chapter, you learned how to manipulate recordsets via code. The chapter began by contrasting ActiveX Data Objects with Data Access Objects. It continued by introducing you to the ADO model. It explored the different types of ADO recordsets available, highlighting why you would want to use each type.Next, you learned how to manipulate recordsets using code. The capability to manipulate recordsets behind the scenes is an important aspect of the VBA language. It frees you from the user interface and enables you to control what is going on programmatically. Finally, you learned how to create and modify database objects using code. This is important if the application you are creating requires you to create or modify tables, queries, or other objects at runtime.The techniques required for ActiveX Data Objects were covered as well as the different coding techniques that are needed for Data Access Objects.
