Jet Data Access Objects

Jet Data Access Objects
Not to be confused with Data access object.

Jet Data Access Objects is a deprecated general programming interface for database access on Microsoft Windows systems. It is unrelated to the data access object design pattern used in object-oriented software design.

Contents

History

DAO were originally called VT Objects. DAO 1.0 came up in November 1992. In version 3.5 it was able to bypass the Jet engine altogether and directly access ODBC data sources, including Microsoft SQL Server and other enterprise database systems. DAO 3.6 was the final version developed by Microsoft. Microsoft says that DAO will not be available in its future 64-bit operating systems.[1]

Design

DAO works by creating a "Workspace" object in which all database operations are performed. The workspace object exists as a session object that exists within a larger database engine object. There are two types of database engines: a Jet database engine object, and an ODBCDirect database engine.

Jet

The Jet database engine object consists of several objects:

  • a workspace object containing
  • a groups-and-users object
  • a database object containing objects which consist of
    • containers of objects
    • query definition (QueryDef) objects
    • Recordset objects which are defined by a set of field objects
    • relation objects which show the relationship between different fields in the database
    • table definition (TableDef) objects which consists of fields and indexes of selected fields.
    • a series of error objects

ODBCDirect

The ODBCDirect database engine consists of a workspace object and an errors object. The main differences between this database engine and the Jet database engine are:

  • the workspace object contains only a series of ODBC connection objects
  • the database object consists of a series of recordset objects

The ODBC connection objects consist of QueryDef objects and recordset objects.

See also

References

  1. ^ Data Access Technologies Road Map

Wikimedia Foundation. 2010.

Игры ⚽ Нужно решить контрольную?

Look at other dictionaries:

  • Data Access Objects — is a general programming interface for database access on Microsoft Windows systems and should not be confused with the Data Access Object design pattern used in object oriented software design. History DAO were originally called VT Objects. DAO… …   Wikipedia

  • Data Access Objects — Saltar a navegación, búsqueda Data Access Objects (DAO, Objetos de Acceso a Datos) es una interfaz orientada a objetos creada por Microsoft la cual permitía a las primeras versiones de Microsoft Access y Visual Basic utilizar el motor de base de… …   Wikipedia Español

  • Data Access Objects — Data Access Objects, in der deutschsprachigen Dokumentation „Datenzugriffsobjekte“, üblicherweise mit der Abkürzung „DAO“ bezeichnet, ist eine Schnittstellen Bibliothek von Microsoft für den Zugriff auf Daten und Strukturen von Datenbanken,… …   Deutsch Wikipedia

  • Data Access Objects — У этого термина существуют и другие значения, см. DAO. Data Access Objects (DAO)  технология доступа к данным компании Microsoft. Содержание 1 История 2 DAO и системы клиент сервер …   Википедия

  • Microsoft Data Access Components — MDAC redirects here. For other uses, see MDAC (disambiguation). MDAC (Microsoft Data Access Components) Microsoft Corporation s MDAC provides a uniform framework for accessing a variety of data sources on their Windows platform. Developer(s)… …   Wikipedia

  • Microsoft Data Access Components — Este artículo o sección necesita referencias que aparezcan en una publicación acreditada, como revistas especializadas, monografías, prensa diaria o páginas de Internet fidedignas. Puedes añadirlas así o avisar …   Wikipedia Español

  • Data Protection API — (DPAPI) криптографический интерфейс программирования приложений в ОС семейства Windows, обеспечивающий защиту (конфиденциальность) данных путём их шифрования. Архитектура DPAPI включает в себя функции: шифрования и расшифровки данных, а также… …   Википедия

  • Data Protection API — DPAPI (Data Protection Application Programming Interface) is a simple cryptographic application programming interface available as a built in component in Windows 2000 and later versions of Microsoft Windows operating systems. In theory the Data… …   Wikipedia

  • Microsoft Access — Microsoft Office Access 2010 running on Windows 7 Developer(s) Microsoft Corporation …   Wikipedia

  • Microsoft Jet Database Engine — This article is about JET Red used in Microsoft Access. For the JET Blue ISAM implementation, see Extensible Storage Engine. The Microsoft Jet Database Engine is a database engine on which several Microsoft products have been built. A database… …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”