Access | data | Microsoft Microsoft's data access technology has the following categories:
First, UDA (universaldataaccess)
This is the universal data access policy provided by Microsoft. Includes ADO, OLE DB, and ODBC. It not only provides access to the database, but also supports other data storage technologies, such as directory services, Excel tabular data, and Exchange Server data.
Ii. ODBC (opendatabaseconnectivity)
This is currently recognized as the best data access technology. The ODBC architecture includes a common sql-based API that uses the corresponding drivers to develop specific database programs. The technology market is huge and is supported for any current database, so ODBC will still be used for a long time.
Iii. RDO (remotedataobjects)
It provides an encapsulation of COM for ODBC. The goal is to simplify the development of ODBC and develop ODBC in VisualBasic and VBA programs.
Four, Jet
Jet is the database engine that is installed in MS Access. Jet supports the MDB database and ODBC for MS Access itself.
V. DAO (dataaccessobjects)
It is another COM based data access API. DAO provides encapsulation of Jet and ODBC.
VI. ODBCDirect
ODBCDirect Microsoft later added direct access to ODBC for DAO. is stronger than using Jet to support ODBC.
VII. OLE DB
This is a common and simplified COM based data access rules and APIs. OLE DB is designed to be independent of the special database backend and underlying structure, and it is Microsoft's latest data Connectivity scenario. OLE DB providers can establish links to any data store through OLE DB.
Viii. ADO (activexdataobjects)
ADO provides developers with a more user-friendly encapsulation of OLE DB.
Ix. RDS (remotedataservices)
This is a technology of remote access to ADO data source based on ADO for the establishment of multi-user system. RDS used to be ADC (Advanceddataconnector).
X. MDAC (microsoftdataaccesscomponents)
MDAC is a validated distributed UDA implementation and file. Includes four different technologies: ODBC, OLE DB, ADO, and RDS.
