ACC2000: Operation Stops When Editing Linked SQL Tables

ID: Q209615

The information in this article applies to:

Microsoft Access 2000

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

Microsoft Access may return an inconsistent value for a floating-point field in an SQL table when it checks the value of the field before editing and before updating. This can result in the error message

Data Has changed; Operation Stopped

when you are trying to update a record in a linked SQL table.

CAUSE

This behavior may occur when an SQL indexed field data type is set to either Date/Time or Float.

RESOLUTION

Remove the index from any field that has the Date/Time or Float data type.

To obtain information on any index within a SQL table, you can run the following system stored procedure within the System Administrator Facility (SAF):

sp_helpindex <Table Name>

To remove an index, use the following command:

DROP INDEX <Table_Name.Index_Name>

Note that you must be logged on to the SQL Server as either the table owner or the System Administrator.

Additional query words: prb

Keywords : kberrmsg kbusage kbdta OdbcOthr
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb