Microsoft KB Archive/185163

= PRB: Operation Stopped: Data Has Changed =

Article ID: 185163

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Visual Basic 5.0 Learning Edition
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition
 * Microsoft Visual Basic 4.0 Standard Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 16-bit Enterprise Edition
 * Microsoft Visual Basic 4.0 32-Bit Enterprise Edition

-



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.

