Why This Chapter Is Important
ActiveX Data Objects (ADO) and Data Access Objects (DAO) are used to create, modify, and remove Jet Engine, SQL Server, or other open database connectivity (ODBC) objects via code. They give you the flexibility to move beyond the user interface to manipulate data stored in the Jet Engine and other formats. Some of the many tasks that you can perform with either ADO or DAO include the following:
- Analyzing the structure of an existing database
- Adding or modifying tables and queries
- Creating new databases
- Changing the underlying definitions for queries by modifying the SQL on which the query is based
- Traversing through sets of records
- Administrating security
- Modifying table data