O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

19.6. Summary

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required