1) 9/30/2004 304100304100  304100.html">How To Use ADO to Determine If a Field Is an AutoNumber Field in an Access Table
(304100) - Using the Microsoft OLE DB Provider for Jet 4.0 in ADO, you can use the dynamic property ISAUTOINCREMENT to determine if a field is an AutoNumber field. This property also allows you to determine if the field is an Identity field in a Microsoft SQL...

2) 9/29/2004 296173296173  296173.html">How To Use ADOX to Create an OLE Object Field in an Access Database
(296173) - This article describes how to use ActiveX Data Objects Extensibility (ADOX) to create an OLE Object field in a Microsoft Access Database (.mdb file). You must use the adLongVarBinary constant to create the field. You do not have to specify a field...

3) 7/15/2004 251021251021  251021.html">How To Update Stored Procedures with Joined Tables Using ADO
(251021) - When you use client-side cursors and a command with joined tables, the foreign table fields do not get updated after you change the foreign key value. This article demonstrates how to use the UNIQUE TABLE and RESYNC COMMAND properties to achieve the...

4) 7/15/2004 249718249718  249718.html">HOWTO: Use ADO to Determine the Tables Contained in a DBC
(249718) - The ActiveX Data Objects (ADO) Connection object's OpenSchema method allows programmatic access to metadata about various database containers. You can use the OpenSchema method to determine what tables are contained in a Database Container (DBC), as...

5) 7/15/2004 234552234552  234552.html">How To Use ADOMD to Return Out of Process Cellset
(234552) - You may use ADOMD with the MSOLAP provider to return an Out of Process Cellset. This is useful with DCOM/MTS business objects. This code sample requires the MSOLAP OLEDB provider on the client computer and the Food Mart OLAP database on SQL Server...

6) 7/15/2004 230114230114  230114.html">How To Use UDT to Return State Info for Out-of-Process Record
(230114) - Not all state information is marshalled for an out-of-process ADO Recordset. This is done for performance reasons. For details, please refer to the following article in the Microsoft Knowledge Base: 185423 PRB: Most ADO Recordset Properties Are Not...

7) 7/7/2004 249097249097  249097.html">How To Re-Shape a Hierarchical Recordset
(249097) - MDAC 2.1 introduces re-shaping as a feature of the MSDataShape provider. This article discusses how re-shaping can benefit an application and contains samples to illustrate the concepts.

8) 7/7/2004 245179245179  245179.html">How To Process Multiple Recordsets and Messages in ADO
(245179) - This article contains a generic function for processing multiple recordsets and other messages that can be returned from stored procedures or the execution of batch SQL statements.

9) 7/7/2004 213364213364  213364.html">How To Retrieve an ADOMD Cellset as an ADODB Recordset
(213364) - The ActiveX Data Objects Multi-Dimensional Library (ADOMD) documentation ("Using ADO with ADO MD") indicates that you can access a multidimensional data provider using ADOMD cellsets or ADODB recordsets. The operation of flattening a dataset to...

10) 7/3/2004 259379259379  259379.html">How To Develop with ADO Version 2.5 or Later and Install on ADO Version 2.0
(259379) - Developers often have the latest software, while their customers may use an older version. Microsoft Windows 2000 comes with Microsoft Data Access Components (MDAC) version 2.5 installed. Developers who use Windows 2000 and who want to install their...

11) 7/3/2004 251329251329  251329.html">How To Modify the Command of a Hierarchical DataReport
(251329) - This article demonstrates how to base a DataReport on a hierarchical DataEnvironment and refresh the report after changing the command text.

12) 7/3/2004 245408245408  245408.html">How To Find a Record Using Complex Criteria with ADO
(245408) - This article details a method to work around limitations of the ADO Recordset Find method. Functionality provided in the following custom written class includes the ability to search on multiple fields, text literals containing quotes, and complex...

13) 7/3/2004 235944235944  235944.html">How To Position a DataList Control Directly Under a Cell in a DataGrid
(235944) - This article explains how to place an unbound DataList control under an associated child cell in a DataGrid. When the user presses the DataGrid button, the DataList is displayed and appears as if the related cell had a Combo box.

14) 7/3/2004 230588230588  230588.html">How To Link and Refresh Linked Jet Tables Using ADOX
(230588) - You can update the connection information for a linked table by using the Data Access Objects (DAO) RefreshLink method. This article describes another way to do this with ActiveX Data Objects (ADO) version 2.1 and later by using the Tables collection...

15) 7/3/2004 228451228451  228451.html">How To Navigate an ADO Recordset without Saving Changes to Current Record
(228451) - You are developing an application with Visual Basic and ADO that allows users to view and edit records in a database. The user navigates to a particular record, makes a change, and then tries to move to another record. In response, your application...