Microsoft KB Archive/93146

{|
 * width="100%"|

ACC1x: &quot;Data Has Changed, Operation Aborted&quot; Error Message

 * }

Q93146

-

The information in this article applies to:


 * Microsoft Access 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.

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 : kb3rdparty kberrmsg

Issue type : kbbug

Technology :