Microsoft KB Archive/236825

= PRB: #deleted seen when SQL Server 7.0 tables or SQL Server 6.5 tables that are linked to Access 97 or Access 2000 are opened =

Article ID: 236825

Article Last Modified on 1/6/2005

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Access 2000 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q236825



SYMPTOMS
If Microsoft Access 97 or Microsoft Access 2000 is used to link SQL Server 6.5 or 7.0 tables that have numeric and text field columns, #deleted is seen in alternate rows if the SQL Server database is created by using non default code pages and Sort Order. This behavior can be reproduced when code pages are cp850 or cp437, and the sort order is binary, case insensitive.

This error is only seen with the Microsoft ODBC SQL Server Driver version 3.70.0623.



RESOLUTION
To work around this problem, clear the Perform translation for character data option when configuring the data source name (DSN).



STATUS
This problem does not exist with previous or later versions of the Microsoft ODBC SQL Server Driver.



MORE INFORMATION
Additionally, using the Microsoft ODBC SQL Server Driver version 3.70.0623 with a pass-through query does not generate the #delete error.

Steps to reproduce the behavior
/* From the ODBC Administrator version 3.510.3711 (MDAC 2.1 SP1(GA)) */  Create a system DSN that uses SQL Server 7.0, using the default settings, and connect to the pubs database. Using Microsoft Access, link the Employee and Discounts tables through the DSN created in step 1. Open the linked tables and you will see #deleted in alternate rows.  Run a SQL specific pass-through query using the same DSN and then run either of the following SQL statements: Select * from employee Select * from discounts The data returns correctly unlike the data in the linked tables.  Close Microsoft Access 97 or 2000. Open the ODBC Administrator and re-configure the system DSN so that the Perform translation for character data option check box is clear (the check box is selected by default). Open Microsoft Access 97 or 2000 again, and then connect to these linked tables and the data returns correctly.  Run a SQL specific pass-through query using the re-configured DSN, and then run either of the following SQL statements : Select * from employee Select * from discounts Again, the data returns correctly. </li></ol>

Additional query words: pounddeleted

Keywords: kbdatabase kbprb kbmdacnosweep kbpending KB236825

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.