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 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.