After completing this lesson, you will be able to:Estimated lesson time 90 minutes
- Compare and contrast Data Access Objects (DAO), Remote Data Objects (RDO), and ActiveX Data Objects (ADO).
- Explain the implementation considerations for the most common data access interfaces.
- Connect to a data source and return records using DAO, RDO, and ADO.
- Describe the function of SQL-DMO.
DAO, RDO, ADO and SQL-DMO are data access methods built to retrieve and manipulate data in relational databases. The models perform similar functions; however, each is optimized for a specific situation. For example, you would use DAO to manipulate records on a local Microsoft Access database, but you would use RDO to manipulate records on a SQL Server database. In addition, each method executes through a different API or database engine.
Before you continue with the lesson, run the Chap07.exe animation located on the CD-ROM that accompanies this book. This animation introduces the data access method available to developers.
Figure 7.1 Database Interfaces for Developers