Microsoft KB Archive/109398

= ACC: Closing Forms, Tables, or Queries Is Slow =

Article ID: 109398

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q109398



SYMPTOMS
Closing forms, tables, or queries based on linked (attached) Sybase SQL Server tables can take a long time.



CAUSE
When you close the table, Microsoft Access issues an ODBC API SQLCancel or SQLFreeStmt call. This tells the server to cancel processing of the current query. However, some network libraries are not able to cancel a query request in an efficient manner. Instead, they continue to read the query results from the server until the process is complete, discarding the results.



RESOLUTION
If you are using standard IPX, append the string "URGENT" (without the quotation marks) to the end of the SQUERY or the  line in the WIN.INI file. Substitute the name of the SQL Server for . This tells the network library that your SQL Server supports in-band attention signals. The new line in the WIN.INI file should look like:

   = 111.111.111.111,3801,URGENT

Sybase SQL Server is manufactured by Sybase Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: slow close SQL Sybase

Keywords: kb3rdparty kbprb KB109398

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.