Understanding Client/Server Query Behavior

Query operations in your client/server application are handled either locally or remotely. With local processing, Microsoft Jet handles the query. With remote processing, the remote database server handles the processing.

To successfully implement a client/server application, you should be aware of the differences between these two types of processing. This section discusses some key differences between local and remote query processing and lists operators and functions that may not be supported by the remote database server. This section also explains how to trace SQL operations.