O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Asynchronous Queries

An asynchronous query is a query during which the calling program does not wait for the server results. Instead, the program continues to run. In descriptions in previous chapters, the client program waited until the data was available in the recordset, for example, when it wanted to open a recordset. The program was locked until after the server delivered the data. The same thing happened during the execution of action queries with command objects: The client program waited until the query was processed.

In Chapter 14, “ Command Objects,” we briefly described several options for executing asynchronous queries. This section describes the use of asynchronous queries in more detail. Why in this chapter about events? The answer ...

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