Databases - MS Access/ADO

Microsoft has decided to kill ODBC (I assume that it works too good) and replace it with ADO (ActiveX Data Objects).

Adoacc.exe Demonstrates Using ADO with MS Access 97 (Q185033)

Microsoft Data Access Components (MDAC). the Universal Data Access Web Site download

ACC2000: Updated Version of Microsoft Jet 4.0 Available in Download Center (Q239114)

INFO: List of Useful Articles Related to MDAC Setup (Q243069)

INFO: What are MDAC, DA SDK, ODBC, OLE DB, ADO, RDS, and ADO/MD? (Q190463)

Open Database Connectivity (ODBC), is an international standard for manipulating relational data using SQL query syntax across disparate datasources. ODBC has the advantage of being an international standard that allows you to manipulate a vast array of relational datasources through numerous ODBC Drivers from both Microsoft and third party vendors. The key disadvantage of ODBC is that it is limited to relational, SQL-syntax based data.

MDAC 1.0 included ODBC Drivers for Access/Jet, SQL Server ...


Paradox | MS Access | Delphi | Visual Basic | Java


MS Access 97

Delphi 5.0

Visual Basic 6.0

Java;en-us;Q243069 Start at q190463;en-us;Q190463 Start at MDAC 2.0 Stack Start at INFO: When Is the Access AutoNumber Field Available? (Q244136)

Author: Robert Clemenzi -
URL: http:// / user / clemenzi / technical / Databases / MSAccess / ADO.html