The information in this article applies to:
SYMPTOMSWhen you run a query in Microsoft Query, the query is not run in the background (asynchronously). CAUSEThis problem occurs when one of the following conditions is true:
-or- RESOLUTION
To run your query asynchronously, use the appropriate method:
-or- MORE INFORMATIONAsynchronous QueriesMicrosoft Excel 97 can execute a query in the background, or asynchronously. Microsoft Excel 97 can execute a query and get data asynchronously with ODBC drivers that support asynchronous behavior. All Microsoft ODBC 3.0 drivers support asynchronous executions. Asynchronous execution runs the query in the background so that control is returned to Microsoft Excel while the external data is retrieved.Earlier versions of Microsoft Excel use synchronous queries only. With synchronous queries, you cannot run the query in the background, and the query must be finished before control is returned to Microsoft Excel. Saving Query Definitions and Enabling Background RefreshAfter you select the option to return data to Microsoft Excel from Microsoft Query or the Query Wizard, the "Returning External Data to Microsoft Excel" dialog box appears. In this dialog box, click Properties. The "External Data Range Properties" dialog box appears. To enable background refresh, check both the Save Query Definition check box and the Enable Background Refresh check box. (Both of these options are checked by default.)After the data is returned to Microsoft Excel, if you saved the query definition with the worksheet, you may access the properties for the external data range. To do this, use the following steps:
For more information about executing background queries while a macro runs, please see the following article in the Microsoft Knowledge Base: Q157090 Background Queries Suspended While Macro Executes REFERENCESFor more information about running background queries, click the Index tab in Microsoft Excel Help, type the following text queries, backgroundand then double-click the selected text to go to the "Run a query in the background or while you wait" topic. Additional query words: XL97 async query asynch msquery
Keywords : kbinterop kbualink97 xlquery |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |