Why This Chapter Is Important
You use ActiveX data objects (ADO) to create, modify, and remove Jet Engine, SQL Server, or other OLE DB objects via code. ADO gives 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 ADO include:
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 sets of records
Administrating security
Modifying table data
Get Alison Balter's Mastering Access 2002 Enterprise Development 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.