- Why This Chapter Is Important
- Understanding the Client/Server Model
- Deciding Whether to Use the Client/Server Model
- The Roles Access Plays in the Application Design Model
- Learning the Client/Server Buzzwords
- Upsizing: What to Worry About
- Proactively Preparing for Upsizing
- Using the Upsizing Wizard
- Defining an ODBC Data Source
- Connecting to a Database Server
- Summary
Summary
In this chapter, you learned to be concerned with client/server technology when dealing with large volumes of data, large numbers of concurrent users, a demand for faster performance, problems with increased network traffic, backup and recovery, security, and a need to share data among multiple front-end tools. You also learned the roles Access can play in the application design model. In particular, you learned about upsizing and the various ways you can interface with a client/server database, including using Access Data Projects (ADPs). ADP files were introduced with Access 2000. They allow you to connect directly to a Microsoft SQL Server database. Many client/server buzzwords and concepts also were introduced in the chapter.