FIX: #Deleted After Microsoft Access Sorts a SQL Server Table (166298)
The information in this article applies to:
This article was previously published under Q166298
BUG #: 16387 (Windows NT: 6.5)
SYMPTOMS
If you use Microsoft Access 97 to link to a SQL Server 6.5 table, open the
table in datasheet view, and right-click a column heading and select Sort
Descending, #Deleted appears as the value for some of the records.
CAUSE
The problem occurs when variable length fields have padded spaces stored in
the SQL Server table. The worktable used for sorting does not maintain the
padded spaces, so Microsoft Access thinks that the values have been
changed.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 3 for
Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
MORE INFORMATION
This problem may also occur when you connect from Microsoft Access for
Windows 95.
The client computer should use a SQL Server 6.5 version of the SQL Server
ODBC Driver (Sqlsrvr32.dll version 6.50.0201 or higher). If you connect to
SQL Server 6.5 with the SQL Server 6.0 drivers, you will continue to have
this problem.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbbug kbfix kbinterop KB166298 |
|---|
|