"Using ADO in Microsoft Access 2002" white paper is available in Download Center (301987)



The information in this article applies to:

  • Microsoft Access 2002

This article was previously published under Q301987
Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SUMMARY

The ADOAcc02.exe file contains the "Using ADO in Microsoft Access 2002" white paper, which discusses how to use ActiveX Data Objects (ADO) with forms and reports in Microsoft Access 2002. It also discusses the new Client Data Manager (CDM) in Microsoft Access 2002 and how to use ADO with it. The CDM is a new OLE DB service provider created specifically for use in Microsoft Access 2002. It handles data binding between the database engine (Jet or SQL) and Access objects such as forms, reports, and data access pages. This gives developers more flexibility and better update semantics when they are writing ADO code to bind ADO Recordset objects to Access forms.

The following file is available for download from the Microsoft Download Center:
The ADOAcc02.exe file contains the following file:
   ADOAcc02.doc    A Microsoft Word document
				
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

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

MORE INFORMATION

The Table of Contents of ADOAcc02.doc is as follows:
  • INTRODUCTION
  • MICROSOFT CLIENT DATA MANAGER (CDM)
    • Client Data Manager Features
      • Improved Update Semantics with Multi-Table Views
      • Improved Autolookup
      • Provides Stable Cursors
      • Visible Defaults
    • Using ADO Connections with CDM
      • Opening ADO Connections with CDM
      • Sharing an Access ADO Connection Using CDM
  • BINDING MICROSOFT ACCESS FORMS TO ADO RECORDSETS
    • Microsoft SQL Server
    • Microsoft Jet
    • ODBC
    • Oracle
    • Batch Updates Unsupported
  • USING RECORDSETS WITH COMBO BOX AND LIST BOX CONTROLS
    • Setting the Control Recordset Property
    • Retrieving a Recordset from the Control
  • USING ADO RECORDSETS WITH MICROSOFT ACCESS REPORTS
    • Setting the Report Recordset Property
    • Assigning the Recordset Property of an Ungrouped Report
    • Assigning the Recordset Property of Grouped Reports
    • Retrieving the Report Recordset Property
  • FOR MORE INFORMATION

Modification Type:MinorLast Reviewed:8/25/2004
Keywords:kbReport kbdownload kbfile kbgraphxlinkcritical kbhowto KB301987