• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

Two main techniques are available for building client/server applications. The first employs the use of linked tables within a standard database file (.mdb). This method can be quite successful if you build the application so that a minimal amount of data travels over the network wire. The alternative to this technique is to use an Access Project. With an Access Project, you establish a direct connection to the client/server database, and no linked tables are involved. Regardless of the technique employed, the objective is to minimize the data that travels over the network wire. You reduce traffic by ensuring that only the data that the user specifically requests is returned. Techniques that achieve this goal include not requesting data until the user clicks the tab containing that data.

This chapter showed you how to create ADP files. It then walked you through the process of administering a SQL Server database from an ADP file. Finally, it showed you how to design ADP forms and reports that keep network traffic to a minimum.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint