Access Enterprise Development: Introduction to Client/Server Development Techniques
- 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
Why This Chapter Is Important
The previous chapter covered the basics of using Access in a multiuser environment. This chapter takes things a step further by discussing client/server applications. One of the hot computing terms introduced in the 1990s, client/server refers to distributed processing of information. A client/server model involves the storage of data on database servers dedicated to the tasks of processing data and storing it.
The chapter begins by explaining the client/server model. It talks about the roles that Access can play in the design model and about when it is appropriate to utilize the client/server model. You learn the important client/server buzz words and then see how you can upsize your existing Access databases. Finally, the chapter talks about the various ways that you can connect to client/server data.