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.
REFERENCES
Microsoft Jet Database Engine Programmer's Guide, First and Second
Editions.
Additional query words: kbDSupport kbdse
Keywords: kbprb KB185163