ACC1x: "Data Has Changed, Operation Aborted" Error Message

 Last reviewed: May 14, 1997
Article ID: Q93146
The information in this article applies to:
  • Microsoft Access version 1.0

SYMPTOMS

When a user (User1) attempts to commit a record in an attached Paradox table and that record has been changed by another user (User2), User1 sees this error message: 

   Data has changed; operation aborted.
After User1 chooses the OK button, a second error message appears: 

   This record has been changed by another user since you
   began editing it...  Save Record, Copy to Clipboard,
   Drop Changes.
If User1 selects the Save Record option, the first error message is repeated. User1 is caught in a continuous loop, unable to commit the record.

RESOLUTION

To save the changes made to the current record, User1 must:

  1. Select the Copy to Clipboard option.

  2. Select the record User1 was attempting to change.

  3. Choose Paste from the Edit menu.

  4. Commit the record.

User1 can prevent User2 from changing a record while User1 is editing it by changing the multiuser option to Edited Records.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION

Steps to Reproduce Problem

These steps require either two users or two instances of Microsoft Access.

  1. Both users attach to a Paradox Table.

  2. Both users set their multiuser options to No Locks.

  3. User1 starts to edit a field but does not commit the record.

  4. User2 changes and commits the same record by choosing Save Record from the File menu or by moving the cursor to the next record.

  5. User1 attempts to commit the changed record.

    Error Message #1: Data has changed; operation stopped.

    Error Message #2: This record has been changed by another user since you began editing it... Save Record, Copy to Clipboard, Drop Changes.

Additional query words: Misc multi-user transaction
Keywords : IsmPdox kb3rdparty kberrmsg
Version : 1.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.