Appendix E Microsoft Jet Components

Microsoft Jet uses a variety of components, implemented as dynamic-link libraries (DLLs). These DLLs constitute the Jet database engine as a whole. The Microsoft Jet DLLs can be grouped into the following component groups:

DLL group Description
Microsoft Jet DLLs Responsible for storing data in the database file and for providing query and security services.
Data Access Objects (DAO) DLLs Responsible for providing the programming interface to the Jet database engine and ODBCDirect.
External ISAM DLLs Responsible for providing access to external (non-native) data (for example, Microsoft Excel, Microsoft Exchange, HTML, Microsoft FoxPro, Borland dBASE, Corel Paradox, and Lotus 1-2-3).
Replication DLLs Responsible for creating and synchronizing full or partial database replicas at multiple locations.
Visual Basic for Applications (VBA) DLLs VBA is not a component of Microsoft Jet, but it provides the expression service to evaluate functions in SQL statements.
Open Database Connectivity (ODBC) DLL In addition to the components discussed above, Microsoft Jet uses the ODBC Driver Manager DLL to provide access to ODBC data sources.