由于锁冲突，访问无法删除记录 [英] Access Can't delete records due to lock violations

问题描述

过去几年，我们一直在使用 xp 机器的 Access 2003 上使用删除命令，在我们将系统升级到 Access 2010 和 Windows 7 之前，它一直运行良好.

We have been using a Delete command on Access 2003 with xp machine from past few years and it was working good until we upgraded our systems to Access 2010 and Windows 7.

请查看下面的错误.不知道我错过了什么.我尝试创建一个新的链接 oracle 表，但没有奏效.

Please see the error below. No sure what i was missing. I tried creating a new link oracle table, but it didn't work.

推荐答案

我在使用具有主键和唯一键的链接表时出现此错误.链接表时，Access 假定唯一键是主键.

I had this error with a linked table that had a primary key and a unique key. When linking the table, Access assumed the unique key was the primary key.

通过暂时禁用或删除唯一键并使用链接表管理器刷新 ling"，问题得到解决.

By temporarily disabling or deleting the unique key and refreshing the ling using Linked Table Manager" the problem was resolved.

这篇关于由于锁冲突，访问无法删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！