Article ID: 185033
This article was previously published under Q185033
Adoacc.exe is a self-extracting compressed file containing sample code that demonstrates how to use ActiveX Data Objects (ADO) with Microsoft Access 97. The sample code may be converted to use Microsoft Access 2000.
The following file is available for download from the Microsoft Download Center:
ADOACC.EXENOTE: Microsoft Technical Support does not support the use of ADO version 1.x within Microsoft Access 97. This sample is provided purely for informational purposes. Furthermore, this does not demonstrate or reference any OLE DB Provider for Jet. The access to ADO is being done via the OLE DB Provider for ODBC Drivers.
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
(http://support.microsoft.com/kb/119591/EN-US/ )How to Obtain Microsoft Support Files from Online Services
About the ADOACC SampleThe sample Adoacc.mdb database contains four ADO procedures/functions that accomplish the following:
http://msdn.microsoft.com/dataaccessThe structure of the ADO Samples is standardized so that methods, functions and procedures share the same name. Often the layout of comments and whitespace is the same. This allows you to use the WinDiff utility included with both Microsoft Visual C++ and the Microsoft Platform SDK, to compare individual files, or even entire directories.
Key module names have been used in each version of the sample to aid in this comparison:
For additional information, please see the following Web site:
Microsoft Universal Data Access (MDAC) Web page
About the ADO* Series of SamplesThis is one of several identical samples implemented using ADO within various products, as listed below. The advantage is that these articles have an identical interface/functionality, demonstrating both the similarities and differences in using ADO with different languages and environments.
QNumber and Title
(http://support.microsoft.com/kb/172403/EN-US/ )FILE: Adovb.exe Demonstrates How to Use ADO with Visual Basic
(http://support.microsoft.com/kb/220152/EN-US/ )Sample: ADOVC1 Simple ADO/VC++ Application
Article ID: 185033 - Last Review: July 18, 2012 - Revision: 5.0