Alison Balter's Mastering Access 97 Development, Second Edition

Chapter 21. Client/Server Strategies

• Developing Client/Server Strategies

• Selecting the Best Recordset Type

• Using Forward-Scrolling Snapshots

• Using Key Set Fetching

• Using Pass-Through Queries and Stored Procedures

• Using ODBCDirect

• Preconnecting to the Server

• Reducing the Number of Connections

• Optimizing Data Handling

• Optimizing Queries and Forms

• Practical Examples: Using Client/Server Strategies

Developing Client/Server Strategies

As you saw in the preceding chapter, it is very easy to implement client/server strategies ineffectively. This can result in worse performance rather than better performance. The developer's task is to intelligently apply appropriate techniques that deploy client/server systems effectively.

This chapter discusses strategies to help ...