
	Home \| Asp.Net 2.0 \| .Net Framework 2.0 \| IIS 6.0 \| Sql Server 2005 \| Visual Basic 2005 \| c# 2005 \| VS 2005 \| Visual Source Safe 2005

MS Dynamics CRM 3.0

SharePoint Portal Server 2003
SharePoint Server 2007
Dynamics NAV
Dynamics CRM
SharePoint Designer 2007
SharePoint Portal Server 2001
Windows SharePoint Services
Windows SharePoint Services 3.0
Project Server 2003
Project Server 2007
Dynamics – Point of Sale
Dynamics AX
Dynamics GP
Dynamics Retail Management System (RMS)
Dynamics SL
SQL Server 2000
Visual Basic .NET 2003
Visual C# .NET 2003
Visual C++ .NET 2003
Visual C++ 2005
Visual SourceSafe 6.0
Windows Server 2003
Windows Server 2003
Outlook 2003
ADO.NET 1.1
ASP.NET 1.0
Visual Studio Team Foundation Server
Visual Studio 2005 Team Edition
Windows Internet Explorer 7
BizTalk Server 2000
BizTalk Server 2002
BizTalk Server 2004
BizTalk Server 2006
Visual Studio 6.0
Access 2000
Access 2002
Access 2003
Access 2007
Access 97
Collaboration Data Objects 2.0
Commerce Server 2002
Content Management Server 2001
Commerce Server 2007
Content Management Server 2002
Data Access Components 2.7
Data Access Components 2.8
DirectX 9.0b
Office Small Business Accounting 2006
Accounting 2007
ActiveSync 4.1
Class Server 2.0
Groove 2007
Windows Vista
Outlook 2007
OneNote 2003
OneNote 2007
Office X for Mac
Zune software
Zune Live
Zoo Tycoon 2
Flight Simulator 2002
Dungeon Siege II

Cervo Technologies
The Right Source to Outsource

Oracle Database FAQS

Sharepoint Portal Server KB

Outlook 2007 Knowledge Base Articles


	Visual Studio 6.0 Knowledge Base Articles

The following error messages occur: Change canceled during notification, no columns changed (MDAC 2.1) -or- Run-time error '-2147217842(80040e4e) Operation was canceled (MDAC 2.5 and later) This problem occurs with the Jet Provider and does not occur...

The following error messages occur:

Change canceled during notification, no columns changed (MDAC 2.1)

-or-

Run-time error '-2147217842(80040e4e) Operation was canceled (MDAC 2.5 and later)

This problem occurs with the Jet Provider and does not occur with the SQL Server Provider. The problem also does not reproduce with client-side cursors.

The problem doesn't seem to be in the ADODC itself, because you can bind the controls directly to a Recordset object and click on a MoveNext command button to cause the problem.

RESOLUTION

The resolution is to issue a Recordset.Move 0 method in one of the events in the TextBox control.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in the latest service pack for Visual Studio 6.0.

For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

INFO: Visual Studio 6.0 Service Packs, What, Where, Why

How to tell that a Visual Studio service pack is installed

To download the latest Visual Studio service pack, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/vstudio/aa718359.aspx/ (http://msdn2.microsoft.com/en-us/vstudio/aa718359.aspx)

MORE INFORMATION

Steps to Reproduce Behavior

1.	Create a new project and add the ADO Data control and the DataGrid (OLE DB) control to the components.
2.	Add a TextBox, a DataGrid, a CommandButton, and an ADO Data control to the form.
3.	Set the connection string on the ADO Data control to use the JET 4.0 OLEDB provider and then choose the Northwind database.
4.	Add the following code to the project:`Dim rs As ADODB.Recordset Private Sub Form_Load() Set rs = New ADODB.Recordset rs.CursorLocation = adUseServer rs.ActiveConnection = Adodc1.ConnectionString rs.Properties("IRowsetIdentity") = True rs.Open "SELECT * FROM Customers", _ , adOpenKeyset, adLockOptimistic, adCmdText Set Adodc1.Recordset = rs Set DataGrid1.DataSource = Adodc1 Text1.DataField = "CompanyName" Set Text1.DataSource = Adodc1 End Sub Private Sub Command1_Click() rs.MoveNext End Sub`
5.	Run the program.
6.	In the Grid, select an entire row about four lines down. Be sure to click on the Button column on the left so that you select the entire row.
7.	Edit the text in the TextBox (not in the Grid).
8.	In the Grid, select another entire row about four more lines down.
9.	Edit the text in the TextBox.
10.	Click on the Move Next button, and note that you get the error messages listed in the "Symptoms" section of this article.

APPLIES TO

Microsoft ActiveX Data Objects 2.1

Microsoft ActiveX Data Objects 2.1 Service Pack 1

Microsoft ActiveX Data Objects 2.1 Service Pack 2

Microsoft ActiveX Data Objects 2.5

Microsoft OLE DB Provider for Jet 3.51

Microsoft OLE DB Provider for Jet 4.0

Microsoft Visual Basic 6.0 Professional Edition

Microsoft Visual Basic 6.0 Enterprise Edition

kbbug kbdatabase kbfix kbjet kbmdacnosweep kbvs600sp4fix kbvs600sp5fix KB249350