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: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbprb KB185163 |
---|
|