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 ...

MDAC includes ODBC OLE DB ADO RDS.

Paradox | MS Access | Delphi | Visual Basic | Java


Paradox


MS Access 97


Delphi 5.0


Visual Basic 6.0


Java

web2.deskbook.osd.mil/appfiles/RLIB1239.PDF http://support.microsoft.com/default.aspx?scid=kb;en-us;Q243069 Start at q190463 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q190463 Start at MDAC 2.0 Stack http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=msall&Query=odbc%2520ms%2520access%2520ado&Queryc=odbc+ms+access+ado&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=25 Start at INFO: When Is the Access AutoNumber Field Available? (Q244136) http://microsoft.com/data/mdac21info/MDACinstQ.htm


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