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, ...

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.