Microsoft KB Archive/209615

= ACC2000: Operation Stops When Editing Linked SQL Tables =

Article ID: 209615

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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 

To remove an index, use the following command:

DROP INDEX 

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 kbprb kbusage KB209615

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.