交易在锁定时陷入僵局通信缓冲区资源已被选为死锁受害者 [英] transaction was deadlocked on lock | communication buffer resources and has been chosen as the deadlock victim

问题描述

我正在使用Access 2010作为针对SQL-2005数据库运行的项目。我们已经生产了几年。在过去的两周内，有几个用户已经开始使用表单同时更新类似的数据，并开始收到
的消息作为本次讨论的标题。

I'm using Access 2010 as a project running against a SQL-2005 database. We've been in production for several years. In the past two weeks, several users have started simultaneously updating similar data using a form and have started getting the message that's the title of this discussion.

我如何最小化发生此消息？

How can I minimize the occurrence of this message?

每个人都在自己的本地计算机上拥有自己的项目副本。用户都使用相同的表单，但使用不同的数据集。例如，一次使用找到50个项目，然后更新一个，移动到下一个，更新它，移动到下一个，
等。他们可以在每个项目上花费1-5分钟然后移动到下一个项目。每个用户都应该处理不同的项目集，但他们都以类似的方式工作执行相同的任务。

Everyone has their own copy of the project on their local computer. The users are all working with the same form, but working with a different set of data. E.g., one use finds 50 items, then updates one, moves to the next, updates it, moves to the next, etc. They can spend 1-5 minutes on each item before moving to the next one. Each user is supposed to be working on a different set of items, but they are all working in a similar fashion carry out the same tasks.

推荐答案

邮件是来自Access还是来自SQL Server？

Is the message coming from Access or from SQL Server?

您是否已将问题隔离到任何特定的数据更新操作？

Have you isolated the problem to any particular data update operations?

我认为您需要与几个用户进行更新并尝试达到可重现的方案来创建错误。然后，您可以查看代码，以确切了解发生错误时正在执行的操作。

I think you need to run some tests with a couple of users making updates and try to arrive at a reproducible scenario to create the error. Then you can look at the code to see exactly what operations are being performed when the error occurs.

我认为问题在于您的Transact-SQL SELECT或UPDATE语句不包含正确的选项，用于指定锁定的类型/范围。这可能不属于Access论坛的专业知识。当您获得有关正在执行
数据库操作的更多信息时，您可能希望在SQL-Server论坛中发布您的问题。

I'm thinking the problem lies with your Transact-SQL SELECT or UPDATE statements not containing the correct options to specify the type/scope of locking. This probably lies outside the expertise of an Access forum. When you get more information about what database operations are being performed, you might want to post your question in a SQL-Server forum.

这篇关于交易在锁定时陷入僵局通信缓冲区资源已被选为死锁受害者的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！