Object Models
An object model provides the structure to access and modify objects. Microsoft Access 97 used an object model called DAO (Data Access Objects). Starting with Access 2000, ADO (ActiveX Data Objects) became the new standard for Access, though DAO libraries are still available. Although ADO is powerful and more flexible than DAO, DAO still has the overall edge in terms of performance, especially when working with Microsoft Jet.
However, if you plan to access SQL server or Oracle databases, ADO is the preferred choice. Also, because Microsoft considers ADO to be the future of data access technology, it is wise for those wanting to stay on the cutting edge to take advantage of it.
Because the ADO object model is based on the DAO object ...
Get Access 2002 Programming by Example 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.
