PRB: Operation Stopped: Data Has Changed (185163)


The information in this article applies to:

  • Microsoft Visual Basic Learning Edition for Windows 5.0
  • Microsoft Visual Basic Professional Edition for Windows 5.0
  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
  • Microsoft Visual Basic Standard Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
  • Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
  • Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
This article was previously published under Q185163

SYMPTOMS

Using the datacontrol to connect to SQL Server 6.5 via ODBC, when an update is attempted after editing a record, the following error may occur:
3197 "Operation stopped - data has changed" occurs.

CAUSE

The behavior occurs if an SQL field data type is set to Float and the table does not contain a TimeStamp field, or when an SQL indexed field data type is set to either Date/Time or Float.

RESOLUTION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

96897 : ACC: Operation Stops When Editing Attached SQL Tables


STATUS

This behavior is by design.

REFERENCES

Microsoft Jet Database Engine Programmer's Guide, First and Second Editions.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbprb KB185163
©2004 Microsoft Corporation. All rights reserved.