Client-server applications are especially useful when they will be used by a large number of users, or the data needs to be stored on a server. Through careful planning and design, client-server applications can perform splendidly in the right environment.
This chapter discussed how linked tables to ODBC data sources work in Access. You saw several methods for improving performance. One of the largest problems for performance is network bandwidth and local processing of data and queries. Processing joins on the server whenever possible reduces the network bandwidth required for the application and help improve overall performance.
You also examined the major differences between the ACCDB/MDB file formats and the ADP file format. ADP files are specifically designed for working directly with SQL Server and using this file format enables you to leverage many of the rich SQL Server features. Though there are some drawbacks, using ADO provides much of the functionality in an ACCDB or MDB file format.
Whatever file format is chosen for your application, you are sure to find that client-server applications can be extremely useful for multi-user scenarios, data protection, and application scaling. Using SQL Server as the back-end for the client-server application enables you to leverage features and security that SQL Server offers, while providing the flexibility and ease-of-development that Access affords. Using the ADP file format, you can even create and use SQL stored ...