Microsoft KB Archive/209687

= ACC2000: Paste Command Is Unavailable After a Record Is Copied to the Clipboard =

Article ID: 209687

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209687



Novice: Requires knowledge of the user interface on single-user computers.

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



SYMPTOMS
If two users are simultaneously modifying the same record in the same table, the user who tries to save the record last receives the following message:

This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.

Copying the changes to the Clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.

However, if the second user copies the changes to the Clipboard and then decides to paste in changes, the Paste command is unavailable in Microsoft Access.



CAUSE
This behavior occurs because Access does not support pasting records when the focus is in a control.



RESOLUTION
The user can select Paste Append to append the record to the table; or, if the user selects a record to paste to, he or she can then use the Paste command (or CTRL+V).



MORE INFORMATION
For more information about the multiuser capabilities of Microsoft Access, click Microsoft Access Help on the Help menu, type tips for editing access database objects in a multiuser environment in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Keywords: kberrmsg kbprb KB209687

-

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

© Microsoft Corporation. All rights reserved.