• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Access Visual Basic Tools, T... > How to Use DAO and ADO to Manipulate...

How to Use DAO and ADO to Manipulate Data

Although this chapter has presented many programming examples, no “by example” hands-on tips and techniques have been offered so far. This was intentional, because you must understand the fundamentals before you can apply them. The following “by example” will accomplish two purposes at the same time. First, it will give you first-hand knowledge of how to manipulate recordsets using both object models. Second, it will give you a valuable technique that you can easily adapt to your business needs.

It must be reemphasized that there is a need to set references to the proper libraries in the module window, as explained in Chapter 7. In this case, because you work with both DAO and ADO in the following exercises, references to both libraries should be set. If both libraries are set, be sure to reference the proper object model in your dim statements. For example, you declare a recordset object with the statement


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint