Data Access Resources

Microsoft Corporation

Applies To: Office 2000 and earlier versions

July 1999

Summary: This article provides links to data access resources of interest to Microsoft® Office developers, including MSDN articles, Knowledge Base articles, and books. (5 printed pages)

MSDN Library Articles

Microsoft Data Access Backgrounders Overview

Data access backgrounders provide an overview of a broad technical topic or a cross-technology perspective. You can use the information in backgrounders to understand how a technology works, how it compares to other technologies, and to help you decide which technology is right for you to adopt. (This page provides a compilation of links to a dozen backgrounders.)

Microsoft Data Access Technical Articles Overview

This page provides half a dozen links to articles in each of three categories: Microsoft® Data Access Components (MDAC), ActiveX® Data Objects (ADO), and OLE DB. These technical articles provide supplemental information about data access, usually including example code.

ADO and SQL Server Developer’s Guide

This paper introduces ADO and the ADO programming model for application developers who are targeting Microsoft SQL Server™. Particular attention is given to taking advantage of SQL Server features with ADO, such as stored procedures and server cursors.

Creating and Modifying Stored Queries in Microsoft Access Databases with ADOX

This article describes how to create and modify a stored query in an Access database by using Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX).

Implementing Database Replication with JRO

The Microsoft Jet and Replication Objects (JRO) model contains objects, properties, and methods for creating, modifying, and synchronizing replicas. It is designed specifically for use with the Microsoft Jet OLE DB Provider. Unlike ActiveX Data Objects (ADO) and ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX), JRO can’t be used with data sources other than Microsoft Jet databases (.mdb files).

ADO Provider Properties and Settings

This article provides an overview of Microsoft Jet 4.0 Provider Properties.

Knowledge Base Articles

HOWTO: Query and Update Excel Data Using ADO From ASP

http://support.microsoft.com/support/kb/articles/Q195/9/51.ASP

This article demonstrates how to query and update information in a Microsoft Excel spreadsheet by using ActiveX Data Objects (ADO) from an Active Server Page. The article also discusses the limitations associated with this type of application.

HOWTO: Create a Parameter Query via Data Access Objects

http://support.microsoft.com/support/kb/articles/Q142/9/38.asp

This article explains how to create and use a parameter query by using Data Access Objects (DAO). A parameter query is a type of QueryDef specific to the Microsoft Jet database engine used by Microsoft Visual Basic®, Microsoft Access, and other products.

XL: How to Retrieve the Results of a Parameter Query Using DAO

http://support.microsoft.com/support/kb/articles/Q146/6/07.asp

This article demonstrates how with Microsoft Excel 97 you can use Data Access Objects (DAO) in Microsoft Visual Basic for Applications (VBA) to retrieve the results of a Parameter QueryDef from Microsoft Access.

XL97: Returning Data with DAO to a Custom Worksheet Function

http://support.microsoft.com/support/kb/articles/Q167/1/79.ASP

Microsoft Excel allows you to create custom functions by using Visual Basic for Applications. You can also use Data Access Objects (DAO) to programmatically return information from an external database. This article includes sample macro code that uses DAO to return an array of data to a custom worksheet function.

ACC2000: Sample Code to Check for Table or Query in a Database

http://support.microsoft.com/support/kb/articles/Q210/3/98.asp

This advanced-level article contains a sample user-defined function named IsTableQuery() that you can use to determine whether a table or a query exists in a database. The sample function uses the TableDefs and QueryDefs Data Access Objects (DAO) collections.

HOWTO: Using ASP/ADO to Query an ODBC Datasource (SELECT)

http://support.microsoft.com/support/kb/articles/q165/6/71.asp

This article provides an example of an Active Server Pages (ASP) script that can be used to troubleshoot connection problems with ODBC datasources. This example can also be used to demonstrate how to write simple scripts that select data from databases.

WD: ODBC—Open Database Connectivity Overview

http://support.microsoft.com/support/kb/articles/q110/0/93.asp

This article provides an overview and brief FAQ on ODBC, as well as links to other articles with more in-depth information.

FAQ: ActiveX Data Objects (ADO) Frequently Asked Questions

http://support.microsoft.com/support/kb/articles/Q183/6/06.ASP

This article presents some answers to frequently asked questions about programming ActiveX Data Objects (ADO).

ACC2000: How to FIND a Record Using ADO and Jet OLE DB Provider

http://support.microsoft.com/support/kb/articles/Q199/3/04.asp

This article demonstrates how to find records in a Microsoft Jet database by using ActiveX Data Objects (ADO) and OLE DB.

INFO: Issues Migrating from DAO/Jet to ADO/Jet

http://support.microsoft.com/support/kb/articles/q225/0/48.asp

This article discusses issues that need to be taken into account when migrating an application from using DAO and the Jet database engine to using ADO and the Jet database engine.

ACC: How to Optimize MS Access Using ODBC Data Sources

http://support.microsoft.com/support/kb/articles/Q113/5/51.asp

This article provides a list of tips and suggestions on improving performance of Microsoft Access when accessing data from an ODBC data source.

ACC2000: Creating a Parameterized Jet Stored Procedure with DDL

http://support.microsoft.com/support/kb/articles/Q202/1/16.asp

This article shows you how to create a stored procedure in the Visual Basic Environment and, if needed, how to add a parameter to the existing stored procedure.

Books

Microsoft ADO Programmer’s Reference

ADO supports key features for building client/server and Web-based applications. Its primary benefits are ease of use, high speed, low memory overhead, and a small disk footprint. ADO also features Remote Data Service (RDS), by which you can move data from a server to a client application or Web page, manipulate the data on the client, and return updates to the server in a single round trip. This ships as an HTML help file (ado210.chm) with Office 2000.

DAO 3.6 SDK

DAO (Data Access Objects) enables you to use a programming language to access and manipulate data in local or remote databases, and to manage databases, their objects, and their structure.

ODBC Programmer’s Reference

The Microsoft Open Database Connectivity (ODBC) interface is a C programming language interface for database connectivity. This guide addresses the following questions: what is the ODBC interface; hat features does ODBC offer; how do applications use the interface; and how do drivers implement the interface?

Microsoft ADO Extensions for DDL and Security (ADOX) Programmer’s Reference

Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX) is an extension to the ADO objects and programming model. This is contained in the HTML help file (ado210.chm) that ships with Office 2000.

Microsoft ADO MD Programmer’s Reference

Microsoft ActiveX Data Objects (Multidimensional) (ADO MD) provides easy access to multidimensional data from Microsoft Visual Basic. This is contained in the HTML Help file (ado210.chm) that ships with Office 2000.

Microsoft Jet and Replication Objects

Microsoft Jet and Replication Objects (JRO) allow you to add features to your application that are specific to the Microsoft Jet Database Engine. This information is also provided with Office 2000 as an HTML Help file, msjro.chm.