Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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).

↑ Back to the top


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.

↑ Back to the top


Cause

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

↑ Back to the top


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).

↑ Back to the top


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.

↑ Back to the top


Keywords: KB209687, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 209687
Revision : 3
Created on : 7/16/2004
Published on : 7/16/2004
Exists online : False
Views : 265