ACC: Closing Forms, Tables, or Queries Is Slow

Last reviewed: May 28, 1997
Article ID: Q109398
The information in this article applies to:
  • Microsoft Access versions 1.1, 2.0, 7.0, 97

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 <MYDATASOURCE> line in the WIN.INI file. Substitute the name of the SQL Server for <MYDATASOURCE>. 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:

   <MYDATASOURCE> = 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 OdbcOthr
Version : 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.