ACC2000: Paste Command Is Unavailable After a Record Is Copied to the Clipboard (209687)
The information in 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).
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 INFORMATIONFor 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.
| Modification Type: | Minor | Last Reviewed: | 7/16/2004 |
|---|
| Keywords: | kberrmsg kbprb KB209687 |
|---|
|