Microsoft® Access® 2010 Programmer's Reference

Chapter 21. Building Client-Server Applications with Access

WHAT'S IN THIS CHAPTER?

• Building client-server applications using Access 2010 and SQL Server

• Creating a connection to SQL Server from an Access application

• Analyzing and optimizing the performance of an Access application connected to SQL Server

• The differences between using the ACCDB/MDB and ADP file formats against SQL Server

• Implementing both bound and unbound form and report objects to a SQL Server data source

• Building forms and reports in ADPs

Access 2010 makes it easy to create applications that interact with other data source formats and enterprise-level database servers. Unfortunately, the easiest methods are not always the best, and incorrect choices can have serious long-term effects on the design, stability, maintenance, and overall success of a project. A thorough understanding of how Access interacts with other databases and the various alternatives that are available for developers is critical to making the best design decisions for any given application.

Note

Chapters 11 and 12 cover working with many of the objects discussed throughout this chapter. Appendixes B and C also provide more in-depth details about the specific objects, methods, and properties used in this chapter. All of these chapters can be used in conjunction with the material found here and are recommended reading as part of learning about client-server applications.

DATABASE APPLICATION EVOLUTION

In a typical business environment, Access database applications ...