• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 27. Understanding Universal Data... > Gaining a Perspective on Microsoft's...

Gaining a Perspective on Microsoft's New Data Access Components

Access 2000 represents the pivot point of Microsoft's strategy for data access. Under the umbrella of "Universal Data Access," Microsoft wants all Office users, not just Access developers, to abandon Data Access Objects (DAO), ODBCDirect, and the Open Database Connectivity (ODBC) Application Programming Interface (API). Microsoft proposes to substitute a completely new approach to data access based on a new collection of Component Object Model (COM) interfaces called OLE DB. To encourage Access users and developers to adopt OLE DB based programming, all traditional database technologies (referred to by Microsoft as downlevel, a synonym for "obsolete") are destined for maintenance mode. Maintenance mode is a technological purgatory in which Microsoft fixes only the worst bugs and upgrades occur infrequently, if ever. From 1999 on, OLE DB and its derivatives, ActiveX Data Objects (ADO) and ActiveX Data Object Extensions (ADOX), are Microsoft's mainstream data access technologies.

Note

When you upgrade an existing application from an earlier Access version to Access 2000, the new application uses DAO 3.6, which is backward compatible with versions 2.0 through 97. Upgraded client/server and other applications that use ODBC continue to use ODBC for data connectivity. All new applications you create in Access 2000 use ADO 2.1, ADOX 2.1, and OLE DB 2.0. New and upgraded applications that use Access (Jet) databases continue to use Jet 4.0. Access Data Projects (ADP) use ADO 2.1 and OLE DB to connect directly to the Microsoft Data Engine (MSDE) and SQL Server 6.5+, but don't use Jet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint