ACC2000: Operation Stops When Editing Linked SQL Tables (209615)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209615
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.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kberrmsg kbprb kbusage KB209615
©2004 Microsoft Corporation. All rights reserved.