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.
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.
In a typical business environment, Access database applications ...