Alison Balter's Mastering Access 2002 Enterprise Development

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.