O'Reilly logo

F. Scott Barker's Microsoft® Access 2000 Power Programming by F. Scott Barker

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

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

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