Chapter 19. Data Manipulation

IN THIS CHAPTER

Connecting to a Data Source 273

Opening a Recordset 278

Inserting Data 288

Finding Data 294

Updating Data 304

Deleting Data 306

Case Study: Backing Up Data 309

Connecting to a Data Source

To manipulate data, we must first connect to a data source. Those words sound a lot like ADO object model terminology, but the intent is not to focus your attention on ADO but on the concept that to manipulate data, we need to be able to see it.

We look at data through the object models discussed in Chapter 17, “Object Models for Working with Data.” In the ADO object model visibility of data is gained through opening a Connection object. In the DAO object model visibility of data is gained through opening a Database ...

Get Microsoft® Office Access 2007 VBA 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.

Start your free trial