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



APPLIES TO

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



This article was previously published under Q248602

BUG #: 55914 (SQLBUG_70)

SYMPTOMS

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 3.70.06.23, the linked table data is incorrectly shown as #DELETED.

STATUS

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