Article ID: 952287 - View products that this article applies to.
Consider the following scenario:
Note This problem occurs only if the application uses a client-side cursor. If the application uses a server-side cursor, the application is not affected.
This problem occurs in the Microsoft Data Access Components (MDAC) components of the following Windows operating systems:
To resolve this issue, install the hotfix that is described in the following Microsoft Knowledge Base article:
961451Note The hotfix that was described in the "Resolution" section in the earlier version of this article is superseded by the hotfix that is described in 961451.
(http://support.microsoft.com/kb/961451/ )FIX: You receive an incorrect value when you query the last-inserted identity value after you use a client-side cursor to insert data to a table that contains an identity column in an application that uses ActiveX Data Objects
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
This problem affects you if you use Retail Management System (RMS) Store Operations or Headquarters in Microsoft Dynamics on the Windows operating systems that are affected and that are supported. We recommend that you apply this hotfix to prevent invalid data or data loss.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
940569For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/940569/ )On a computer that has Microsoft Data Access Components 2.8 installed, an application receives an incorrect value for the identity column from a SQL Server 2005 database
(http://support.microsoft.com/kb/824684/LN/ )Description of the standard terminology that is used to describe Microsoft software updates
Article ID: 952287 - Last Review: October 8, 2011 - Revision: 5.0
Contact us for more help
Connect with Answer Desk for expert help.