Mastering VBA for Microsoft Office 2007, 2nd Edition

Chapter 29

Manipulating the Data in an Access Database via VBA

This chapter shows you how to begin manipulating the data in an Access database. You can do so either from within Access or from another VBA-enabled application — for example, from Excel or from Word. This chapter shows you how to work from within Access.

There are two main ways to manage data in an Access database: via Data Access Objects (DAO) or via ActiveX Data Objects (ADO). DAO is the older method of accessing data, and it works for both Microsoft Jet databases (Microsoft Jet is the Access database engine) and ODBC-compliant data sources. (ODBC is Open Database Connectivity, a long-existing standard for accessing databases. ODBC is also useful for accessing open source solutions, ...