Browse by Tags

All Tags » SQL Server » bug (RSS)
Sun, Jun 27 2010 17:04

Bug with Access and SQL Server: Erroneous #Deleted bug on Insert with null values

When a new row is inserted into a view that uses identity but contains null values for at least one field and Access' subsequent attempts to locate the new row uses "a_field = NULL" and thus will always fail to find that row and return #Deleted...
Posted by Tony | with no comments
Filed under: , ,
Sat, May 10 2008 22:56

Bug in ADO, SQL Server and latest OS SPs

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000...
Posted by Tony | with no comments
Filed under: , ,
Wed, Nov 7 2007 16:13

Access 2003 SP3 bug on bit data type field in a linked SQL Server table

We've been seeing reports of this in the newsgroups. Here's Microsoft's KB article: After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table
Posted by Tony | with no comments
Filed under: , ,