Access 2013 - 复制然后粘贴会导致删除记录 [英] Access 2013 - copy then paste causes a delete record

问题描述

使用通过ODBC链接到Oracle 11数据库的Access 2013。

在数据表视图中打开一个表。

选择要复制的记录

右键单击并复制记录

插入记录

保存记录然后导致删除记录的显示

刷新然后显示正确插入的记录

为什么删除记录被显示？

解决方案

嗨SA开发者，

总的来说，看起来你正在从一张表中复制行并粘贴通过手动复制并粘贴记录，然后直接显示粘贴在目标表中的记录。它没有显示任何删除记录的消息。

我想与你确认你的数据库中是否有任何宏在你对表执行某些操作时运行？

如果没有，则尝试压缩和修复数据库。

修复数据库后，请尝试复制粘贴记录并测试问题是否仍然存在。

if你的问题没有解决使用上面提到的建议，然后尝试发布删除邮件的图片。

以便我们可以尝试了解它并可以进一步建议你。

问候

Deepak

Using Access 2013 linked via ODBC to Oracle 11 database.

Open a table in datasheet view.

Select record to copy

Right click and copy record

Insert record

Save record then results in a deleted recorded display

Refresh then displays properly inserted record

Why is deleted recorded being displayed?

解决方案

Hi SA Developer,

so overall , it looks like you are copying the row from one table and paste that to another table in the same Access Database manually.

generally when you copy and paste the record then it directly displays the record pasted in the destination table. it does not show any message for record deletion.

I want to confirm with you is there any macro there in your database that runs when you perform some operation on table?

if not, then try to Compact and Repair Database.

after repairing the database please try to copy paste a record and test whether the issue still exist or not.

if your issue not solve using above mentioned suggestion then try to post the picture of that deletion message.

so that we can try to know about it and can suggest you further.

Regards

Deepak

这篇关于Access 2013 - 复制然后粘贴会导致删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！