Data Access Resources
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Applies To: Office 2000 and earlier versions
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 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.
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.
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).
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).
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
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
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
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
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
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)
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
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
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
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
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
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
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.
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.
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 (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.