It supports both Microsoft Jet workspaces (*.mdb files) and ODBC access (via ODBCDirect).
In ADO, DAO and RDO in Visual Basic, Microsoft explains the main differences. Basically, ADO is the newest and should be used for new applications - except in those instances where you need to use DAO.
MS Access 97
Change Dim MyTable As Recordset ' This works with MS Access 97, but fails in 2002/XP to Dim MyTable As DAO.Recordset ' This works in 2000/2002/XP
2 copies of VBA/DAO help are available on my system
html help - DAO360.CHM Normal help - DAO35.HLPDAO360.CHM appears to be available by pressing F1 while in MS Access - look under Contents for Microsoft Data Access Objects 3.60 (DAO).
In Delphi 5.0, I use KADAO ... mainly because it is free and because ADO was not included in Delphi 5 Pro (it is part of Delphi 6 Pro).