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

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