Jet Data Access Objects

Jet Data Access Objects is a general programming interface for database access on Microsoft Windows systems, primarily for Jet and ACE databases.

DAO were originally called "VT Objects.

In version 3.5 it was able to bypass the Jet engine all together and directly access ODBC data sources, including Microsoft SQL Server and other enterprise database systems.

DAO works by creating a "workspace" object in which all database operations are performed.

The main differences between this database engine and the Jet database engine are: The ODBC connection objects consist of QueryDef objects and recordset objects.