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)
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.)
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.
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.
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.
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.
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.
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.
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.
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.
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).
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.
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.
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.
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.
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 (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.
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 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 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.