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.

Microsoft Corporation

January 2000

Applies To: Microsoft Access 2000, Access 97

Summary: This article provides an extensive list of Microsoft® Access development resources from the MSDN, TechNet, Knowledge Base, Office Update, and other Microsoft sites. (18 printed pages)

Access 2000
Data Access Pages
Access Run Time
Database Design
Internet
Replication
ADO
Client/Server
Wizards
Queries
Forms
Upgrading
Source Code Control
Command Bars
Miscellaneous Development Topics
Miscellaneous Resources

This chapter from Rick Dobson's book Programming Microsoft Access 2000 introduces form, report, and class modules; demonstrates how to develop custom properties and methods; and shows simple ways to build classes into your Access applications.

Rick Dobson discusses the new Microsoft Access 2000 development environment. You will learn about the Visual Basic® Editor windows and navigating from traditional application development tools to the Visual Basic Editor. Selected samples will illustrate how to use the Visual Basic Editor to deal with typical Access development issues.

How you install Access 97 and Access 2000 on the same computer depends on whether one of the versions is already installed or whether neither is installed. This Knowledge Base article provides installation instructions for all scenarios.

This Knowledge Base article provides links to topics answering popular questions about Access 2000.

Office User Assistance writer Mark Roberts has updated this article to describe how to deploy a secure data-access-page-based Web site on your intranet or the Internet by using Access and IIS to serve data from Access or SQL Server databases.

This chapter, reproduced from Access 2000 Developer's Handbook, Volume 2, discusses the issues involved in creating and deploying data access pages (DAPs), and takes a look at their various uses, the controls that Access provides for use on the pages, and several issues involved with deploying these pages for end-user applications.

This article focuses on how you can connect data access pages together, either by using the tools provided in the Microsoft Access design environment, or by manipulating the Document Object Model through scripting technologies, such as Microsoft Visual Basic® Scripting Edition (VBScript) and Microsoft JScript®.

Microsoft Program Manager Clint Covington provides step-by-step examples showing how to use Access 2000 to create data access pages for secured Microsoft Access and Microsoft Data Engine (MSDE) databases.

This article describes and provides a link to the sample Web site for Northwind Traders Direct, a simple e-commerce application that uses data access pages, frames, and cookies. It was created by using Microsoft FrontPage® 2000 and Microsoft Access 2000.

This Knowledge Base article explains how to create a Data Access Page that is linked to an Access database in a FrontPage web.

This Knowledge Base article explains the four ways to open the Script Editor from Design view of a data access page.

This paper covers what the Visual Basic® for Applications (VBA) Package and Deployment wizard can and cannot do when packaging Access run-time solutions on Windows® 95/Windows 98 and Windows 2000. Specifically, it covers locating the Package and Deployment wizard, adding the Access run time to a package, using default Start menu shortcuts, creating new shortcuts, adding registry settings, and expected deployment behavior.

This Knowledge Base article summarizes the differences in the user interface between the run-time version of Microsoft Access and the full, retail version.

This Knowledge Base article explains just how large the Access 2000 run-time component is, and why.

This article covers what the Visual Basic® for Applications (VBA) Package and Deployment Wizard can and cannot do when packaging Access run-time solutions on Windows® 95, Windows 98, and Windows 2000. Specifically, it covers locating the Package and Deployment Wizard, adding the Access run-time component to a package, using default Start menu shortcuts, creating new shortcuts, adding registry settings, and expected deployment behavior.

The RELDESIGN.EXE file in the Knowledge Base download center shows you how to plan and design a Microsoft Access database from the ground up. For practical examples, it uses the database design of the Northwind Traders sample database included in the Microsoft Access package.

This article shows you how to use FrontPage to post information to an Access database.

This Knowledge Base article describes how to update information in a Microsoft Access database using FrontPage 2000 and Active Server Pages (ASP).

This article describes how to use the Publish To The Web Wizard in Access 97 to publish static reports and datasheets to the Web. It also covers how to periodically refresh the data you have published to the Web.

This MSDN Library article gives an overview of the Internet features available with Microsoft Access 97 databases and some advantages of using Microsoft Visual InterDev® to display that data. It then describes how to connect to an Access database and how to display its data in Visual InterDev, and details some limitations of this functionality.

This article by Microsoft Support engineer Mike Wachal describes how to perform Internet synchronization of Jet 3.5 databases.

This article by Microsoft Support engineer Mike Wachal (a companion piece to the one above) describes how to perform Internet synchronization of Jet 4.0 databases.

This article outlines several issues you need to consider when making the decision whether to migrate your applications from DAO to ADO.

The primary role of most Office solutions is to turn raw data, often from a broad variety of sources, into usable information. In Microsoft Office 2000, you will mainly use ActiveX® Data Objects (ADO) to work with data programmatically. This article gives a brief overview of ADO along with some specific examples of how to work with databases, Recordset objects, and the data contained in a results set.

Reproduced**from Access 2000 Developer's Handbook, Volume 1.

No matter which program you're using as an interface to your data, at times you'll need programmatic access to your database's structure and its data. You might want to retrieve the schema of a table, create a new index, or walk through the data returned by a query, one row at a time. Perhaps you need to manipulate your application's security or find a particular row on a form. You can accomplish any of these tasks thanks to Access's use of ActiveX Data Objects (ADO) and ADO Extensions for DDL and Security (ADOX), a pair of COM libraries that are part of Microsoft's Universal Data Access strategy for retrieving and manipulating data. This chapter covers the basics of ADO and presents some useful examples along the way.

This article contains information about using Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX) to create and modify stored queries in Microsoft Access databases.

This chapter excerpted from Rick Dobson's book Programming Microsoft Access 2000 reviews the DAO and ADO data access models, with the primary emphasis on ADO as a programming model. It focuses primarily on the ADO object models for Jet in Access and the ADODB and ADOX libraries. Extensive programming examples show you how to accomplish typical database tasks.

Although the ADO specification does not provide for this task, this Knowledge Base article explains how to repair and compact an Access database by using the ADO extension: Microsoft Jet OLE DB Provider and Replication Objects (JRO).

In addition to the server infrastructure, Access Workflow Designer contains two sets of tools: development tools and administration tools. These tools help you create, view, and edit workflow processes, script, permissions, and other team solution functionality.

This article by Acey Bunch discusses the basic mechanics of getting data from an Access 2000 database. It also delves into using SQL to create and alter a database's structure. If you're new to manipulating data in an Access database, this article is a great place to start.

Second in a series of three articles by Acey Bunch, "Intermediate SQL" builds on the concepts covered in the Fundamentals article and gives a much more detailed picture as to what can be accomplished with Microsoft Jet SQL in Access.

Third in a series of three articles by Acey Bunch, "Advanced SQL" builds on the concepts covered in the fundamental and intermediate articles, but this time focuses on SQL syntax that is most often used in a multiuser environment.

This online book is a series of three articles by Acey Bunch and Mark Roberts about developing client/server solutions by using Microsoft Access 2000 project files and tools.

This MSDN Library article explains how to use Microsoft Access (both 97 and 2000) and the Microsoft Exchange and Outlook Data Access Wizard to migrate specific data from cc:Mail to Exchange.

Discusses the benefits of using Microsoft Data Engine (MSDE) in creating desktop and shared database solutions. Covers options for accessing data within MSDE, including ADO and DAO technologies.

This article contains information about creating the USysRegInfo table required by the Access Add-in Manager to install and manage an add-in.

This article contains a link to a sample database with more than 20 query examples. These examples demonstrate how to create many types of queries, including select queries, crosstab queries, totals queries, and SQL pass-through queries. Topics include using a subquery as criteria, referring to a field in the previous or next record, creating a union query, ranking records, creating a SQL pass-through query in code, grouping column headings in a crosstab query, and many more.

This Knowledge Base article shows you how to use a form to specify the criteria for a query in a Microsoft Access project (.adp file).

This Knowledge Base article contains a link to a sample database with more than 30 form examples. These examples demonstrate how to create custom forms for data entry and non-data-entry purposes. Topics include dynamically synchronizing two forms, opening multiple instances of a form, creating an AfterUndo event, lightweight forms, hyperlinks, using balloons, command bars, and many more.

Most earlier-version Microsoft Access databases convert to Microsoft Access 97 with no difficulty. In some rare cases, however, new features can conflict with existing objects and code in the converted database. This white paper summarizes issues you may encounter when you convert your database.

This article shows you how to upsize a Microsoft Access database to the Microsoft SQL Server or to the Microsoft Data Engine (MSDE) by using the Access 2000 Upsizing Wizard. This article covers an introduction to the Upsizing Wizard, what to check before you upsize, design considerations, suggested troubleshooting techniques for common upsizing issues, and additional resources for information.

This MSDN Library article describes how Office Developer Edition Tools (ODE Tools) provides a software component that integrates various source code control products (including Microsoft Visual SourceSafe® into Microsoft Access.

This article by Microsoft Test Lead Shawn McDowell describes how Microsoft Office 2000 Developer provides the Access Source Code Control add-in that integrates source code control into Access by using Microsoft Visual SourceSafe.

The command bars you create in Microsoft® Access are stored with the database in which they are created. If you want to create command bars that are available to more than one database, you must create them in an add-in database and reference that database from each database application where you want the command bars to be available.

This article contains a link to the Graph Sample Database, containing examples of graph types, how to manipulate graphs in Microsoft Graph 8.0, and how to modify graphs by using VBA code.

This article demonstrates how to create context-sensitive help that can be displayed on a form when you press the F1 key.

The Microsoft Access product page is the starting point in any quest for general information about Access.

Microsoft has expanded its online services to a non-proprietary platform with the addition of no-charge Microsoft-sponsored NNTP newsgroups on the Internet. Previously, Microsoft-sponsored electronic service forums were limited to users of CompuServe and MSN. With the creation of these newsgroups, users of Microsoft Access can obtain electronic service support on the Microsoft Support Web site at http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx by using any Internet provider.

This MSDN Library article presents information on upgrading to Access 97 in a question-and-answer format.

Each Knowledge Base (KB) Help file contains all the current KB articles for a particular version of Microsoft Access, the Microsoft Access Distribution Kit, the Microsoft Access Developer's Toolkit, and the Microsoft Office Developer Edition Tools. As with any Windows Help file, each file has a Contents list and can be searched using the Index tab and the Find tab.

This Knowledge Base page provides links to the newest downloads available for Microsoft Access.

The UDA home page provides links to white papers and product downloads, as well as the ADO, ODBC, and OLE DB home pages.