KEEPING CERTAIN ISSUES IN MIND WITH ACCESS AND SQL SERVER

You should now have a better understanding about not only what client/server applications are, but also how to implement them successfully. The most important points to take away from this chapter are the following:

  • Plan your file-server applications with client/server migration in mind. It's easier to do it right the first time than be forced to rework your application later on.

  • Limit your data. Always be conscious of how much data you're passing across your network. Move only as much data as is truly needed.

  • Take advantage of server processes. Make sure that your queries are actually processing on the server. You can use some tracing mechanism to verify this, as mentioned in the section ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial