Before you create a new Project, you need to understand a few basics:

  • The new OLE DB technology

  • The new data link feature

  • The new Microsoft Data Engine

  • The primary objects available in a server database

Introducing OLE DB

OLE DB is a new set of data access utilities that expose data and database structures to your applications. In the past, you've used ODBC to link an Access application to non-Jet data. Although ODBC is still part of the Microsoft Office architecture, the new OLE DB components will be more important than ODBC to your present and future development efforts.

With OLE DB, Microsoft has defined a standardized architecture that provides a connectivity layer to various data types. OLE DB provides access to relational ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.