Using Advanced ADO Features

So far you should feel pretty comfortable using ADO in most of your Microsoft Office Access programming endeavors. What's more, using the knowledge acquired during the last few chapters, you can switch to any other Office application (Excel, Word, PowerPoint, or Outlook) and start programming. Because you already know the ADO methods of accessing databases and manipulating records, all you need to learn is the object model that the specific application is using. Learning a new type library is not very hard. Recall that VBA offers the Object Browser that lists all the application's objects, properties, methods, and intrinsic constants that you may need for writing code. However, if you'd like to accomplish more with ADO, this chapter will introduce you to a couple of more advanced ADO features that will set you apart from beginning programmers. You will learn about fabricating, persisting, disconnecting, cloning, and shaping recordsets. You will also learn how to process data modifications and additions by using ADO transactions.