如何防止此数据库锁定？ [英] How do I keep this database from locking?
问题描述
我目前有一个访问数据库，它是一个通过Access 2010运行的2007文件。在任何给定时间，它都有多达50个用户。所有用户的工作站都设置为在其Access客户端设置中锁定已编辑的记录。问题是它经常锁定。
一些背景：多个用户访问同一记录不是问题。他们都被分为不允许这样做，当我们检查它何时锁定时，没有人曾经在另一个用户之上。
数据库是分开的。
前端数据库只允许访问一个表单。在此表单中是子表单。
主窗体显示客户端信息。子表单包含该客户端的呼叫记录。它们由唯一的客户端ID链接。
我无法解释：子窗体上的两个字段是记录呼叫代码的组合框。第一个存储一个简单的是/否，我们是否联系。第二个存储客户端响应的代码。默认情况下，联系人yes / no显示no，代码显示NOM。 （没有提出要约）。如果其中任何一个发生更改，数据库将永远不会锁定。如果他们离开（他们通常是因为我们只与客户进行约23％的联系），数据库会说无法更新;目前已锁定。
这是一个荒谬的问题，我无法找到解决方案。拜托，任何人，你的帮助将不胜感激！谢谢。
你好Jesse，
如果删除组合框的默认值会怎样？
不确定。今晚，当我可以获得独家访问权限时，我会这样做。
我发现即使这些字段已被更改，它也会锁定。我被误导了。
没有任何区别。它发生在记录出口。
I currently have an access database that is a 2007 file that is operated through Access 2010. It has as many as fifty users on it at any given time. All of the user''s workstations are set to lock edited records in their Access client settings. The problem is that it is routinely locking up still.
Some background: it is not a problem with more than one user accessing the same record. They are all divided to not allow this and when we check when it locks, no one has ever been on top of another user.
The database is split.
The front end database only allows access to one form. In this form is a subform.
The main form shows client information. The subform contains call records to that client. They are linked by the unique client ID.
What I cannot explain: Two of the fields on the subform are combo boxes that record codes for the call. The first stores a simple yes/no to whether or not we make contact. The second stores the code of the client''s response. By default, the contact yes/no shows no and the code shows "NOM" (no offer made). If either of these are changed, the database will never lock. If they are left (which they usually are as we only make about 23% contact with clients), the database will say "could not update; currently locked."
This is a ridiculous problem that I cannot find a solution for. Please, anyone, you''re help would be greatly appreciated! Thank you.
Hi Jesse,
What happens if you remove the default for the combo boxes?
Not sure. I''ll do that tonight when I can get exclusive access.
I just found out that it is locking even those fields are changed. I was misinformed on that one.
No difference at all. It happens on the record exit.
这篇关于如何防止此数据库锁定？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
