PRB: Operation Stopped: Data Has Changed

ID: Q185163

The information in this article applies to:

Microsoft Visual Basic Learning, Professional, and Enterprise Editions for Windows, version 5.0
Microsoft Visual Basic Standard, Professional, and Enterprise Editions, 16-bit and 32-bit, for Windows, version 4.0

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:

Q96897 : 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 : kbnokeyword kbGrpVBDB
Version : WINDOWS:4.0,5.0
Platform : WINDOWS
Issue type : kbprb