Microsoft KB Archive/301987

= &quot;Using ADO in Microsoft Access 2002&quot; white paper is available in Download Center =

Article ID: 301987

Article Last Modified on 8/25/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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 &quot;Using ADO in Microsoft Access 2002&quot; 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:

Download ADOAcc02.exe now

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

Additional query words: whitepaper

Keywords: kbhowto kbdownload kbgraphxlinkcritical kbfile kbreport KB301987

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.