Microsoft KB Archive/821703

= ACC2002: JET Commits a SQL Server Transaction Instead of Rolling the Transaction Back =

Article ID: 821703

Article Last Modified on 11/17/2003

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Access 2002 Standard Edition

-





SYMPTOMS
When you try to roll back a record, Microsoft Jet may commit the record instead.



CAUSE
This issue may occur when all the following conditions are true:
 * The code tries to roll back a new record that is added to a recordset.
 * The recordset is based on a local table that is linked to a SQL Server-based table.
 * The recordset data results from a query that contains a WHERE clause.



RESOLUTION
To resolve this issue, obtain the latest Microsoft Jet 4.0 service pack that contains an updated version of the Microsoft Jet 4.0 database engine.

For additional information about how to obtain the latest version of the Jet 4.0 database engine, click the following article number to view the article in the Microsoft Knowledge Base:

239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: rollback

Keywords: kbbug kbqfe KB821703

-

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

© Microsoft Corporation. All rights reserved.