Export (0) Print
Expand All
Expand Minimize

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)

Contents

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

Access 2000

Microsoft Access 2000: Class, Form, and Report Modules

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.

Microsoft Access 2000: A Look at the New Visual Basic Environment

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 to Install Access 97 and Access 2000 on the Same Computer

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.

Access 2000 Frequently Asked Questions

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

Data Access Pages

Deploying Data Access Pages on the Internet or Your Intranet

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.

Chapter 10: Creating Data Access Pages

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.

Connecting Data Access Pages Together

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®.

Creating Secure Data Access Pages

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.

Northwind Traders Direct Sample Application

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.

How to Create a Data Access Page Linked to Access Database in FrontPage Web

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

How to Open a Data Access Page in the Script Editor

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

Access Run Time

Using the Package and Deployment Wizard to Package Microsoft Access Run-Time Solutions

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.

Differences Between Retail and Run-Time Microsoft Access

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

Access 2000 Run-Time Component Is Significantly Larger Than Access 97 Run-Time Component

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

Using the Package and Deployment Wizard to Package Microsoft Access Run-Time Solutions

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.

Database Design

Understanding Relational Database Design

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.

Internet

How to Post Information to a Microsoft Access Database Using ASP

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

How to Update Information in a Microsoft Access Database Using FrontPage 2000 and ASP

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

Using Microsoft Access 97 to Share Static Data on the Web

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.

Using Visual InterDev with Microsoft Access

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.

Replication

Internet Synchronization with Microsoft Jet 3.5

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

Internet Synchronization with the Microsoft Jet Database Engine: A Technical Overview

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.

ADO

Issues Migrating from DAO/Jet to ADO/Jet

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

Working with Data in Office Solutions

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.

Chapter 6: ActiveX Data Objects

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.

Creating and Modifying Stored Queries in Microsoft Access Databases with ADOX

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.

Microsoft Access 2000: Data Access Models

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.

Compacting Microsoft Access Database via ADO

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

Client/Server

Access Workflow Designer Tools

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.

Fundamental Microsoft Jet SQL for Access 2000

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.

Intermediate Microsoft Jet SQL for Access 2000

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.

Advanced Microsoft Jet SQL in Access 2000

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.

Developing Client/Server Solutions with Access 2000 Projects

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.

Using Microsoft Access to Migrate cc:Mail Data to Exchange Server

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.

Microsoft Data Engine (MSDE) for Microsoft Visual Studio 6.0: An Alternative to Jet for Building Desktop and Shared Solutions

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.

Wizards

Creating the USysRegInfo Table for a Microsoft Access 2000 Add-In

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

Queries

Microsoft Access Sample Queries Available in Download Center

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.

How to Implement Query-By-Form in a Microsoft Access Project

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

Forms

Microsoft Access 97 Sample Forms Available in Download Center

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.

Upgrading

Microsoft Access 97 Conversion Issues

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.

How to use Access 2000 Upsizing Wizard

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.

Source Code Control

Source Code Control in Microsoft Access 2000

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.

Source Code Control in Microsoft Access 2000

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.

Command Bars

Microsoft Access Command Bars

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.

Miscellaneous Development Topics

Microsoft Access 97 Sample Graphs Available in Download Center

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.

How to Create Context-Sensitive Help for a Microsoft Access Database

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

Miscellaneous Resources

Microsoft Access Product Page

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

Microsoft Access newsgroups available on the Internet

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.

ACC: Microsoft Access Knowledge Base Help Files Available in Download Center

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.

Microsoft Access Most Recent Downloads

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

Microsoft Universal Data Access Web Site

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

Show:
© 2014 Microsoft