ACC: Closing Forms, Tables, or Queries Is Slow (109398)
The information in this article applies to:
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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 <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.
| Modification Type: | Major | Last Reviewed: | 5/6/2003 |
|---|
| Keywords: | kb3rdparty kbprb KB109398 |
|---|
|