Microsoft KB Archive/248602

From BetaArchive Wiki
Knowledge Base

BUG: ODBC Driver Incorrectly Shows Linked Data as #DELETED

Article ID: 248602

Article Last Modified on 10/31/2003


  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition

This article was previously published under Q248602

BUG #: 55914 (SQLBUG_70)


When you use Microsoft Access 97 and the SQL Server ODBC driver version 2.65.xx to link a table on a SQL Server specifically configured as follows:

   Character Set: 850 (MultiLingual)
   Sort Order: Binary Order (bin_cp850)
   Unicode Collation: Binary Unicode Collation (ID = 33280)

the linked table shows valid data rows. After you upgrade to Microsoft Access 2000, which uses the SQL Server ODBC driver version, the linked table data is incorrectly shown as #DELETED.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB248602