Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
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 - View products that this article applies to.
This article was previously published under Q236825
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.
To work around this problem, clear the Perform translation for character data option when configuring the data source name (DSN).
This problem does not exist with previous or later versions of the Microsoft ODBC SQL Server Driver.
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)) */
Article ID: 236825 - Last Review: January 6, 2005 - Revision: 6.2