仅在服务器上写入冲突错误

仅在服务器上写入冲突错误

问题描述:

我在服务器上发生了2个奇怪的问题。


首先 - 我收到查询写入冲突错误(附图像)。任何其他计算机上都没有发生此错误,但是当我在部署服务器上进行测试时,我收到错误。我试图用新版本的软件替换前端和后端(在另一台计算机上部署时工作正常的版本)。

I have 2 odd issues occurring on a server.

First - I''m getting a query write conflict error (image attached). This error is not occurring on any other computer but when I test on the deployment server I get the error. I''ve tried to replace the front end and the back end with new versions of the software (versions that are working fine when deployed on another computer).

附加图像
Write Conflict.png (17.8 KB,396 views)
Attached Images
Write Conflict.png (17.8 KB, 396 views)

这错误通常表示两个单独的用户(或者,更技术上是进程)已标记数据库的相同部分以进行更新工作。


您的配置设置控制进程应如何处理冲突,以及数据库的数量被认为是相关部分。


我怀疑差异可能更多与Access的配置方式(选项等)有关,而不是它运行的操作系统。当然,包括操作系统绝对是提出问题的正确方法。我只是觉得它不会成为这个问题。我会比较你工作的机器和那些不同的机器之间的所有不同选项。看看有什么不同。
This error generally indicates that two separate users (or, more technically, processes) have flagged that same part of the database for update work.

Your configuration settings control how the process should handle conflicts, as well as how much of the database is considered to be the relevant part.

I suspect the difference is probably more with how Access has been configured (Options etc) than which OS it''s running on. Including the OS is definitely the right way to ask the question, of course. I just don''t think it''ll turn out to be the issue on this one. I''d compare all your different options between the machines that work and those that don''t and see what''s different.


感谢您的回复,NeoPa。


我有更多的信息可以解释这个问题。


问题始于我的最新更新,其中包含一个单独的新字段表。我目前将表单'的记录源绑定到SQL语句(直接输入到记录源 - 也就是说,不是查询)。


更新之前,记录源SQL只是一个表。在我最近的更新之后,我需要从另一个表中为过滤器添加一个新字段。当我带来第二个字段时,我得到写冲突(仍然只是在服务器上 - 所有其他计算机工作正常)。我想纠正这个问题,如果可能的话,在服务器上工作。我在下面列出了之前和之后的SQL语句;不确定这是否会有所帮助。


原始SQL记录源声明 - 工作正常:
Thanks for your reply, NeoPa.

I have some more information that may shed some light on this issue.

The problem began on my latest update which incorporated a new field from a separate table. I currently have my form''s record source bound to an SQL statement (entered directly into the record source - that is to say, not a query).

Prior to the update, the record source SQL was just a single table. After my most recent update, I needed to bring a new field in from another table for the filter. When I bring this second field in, I am getting the Write Conflict (still just on the server - all other computers work fine). I would like to correct this issue to work on the server if possible. I''ve included the before and after SQL statements below; not sure if this will help at all.

Original SQL Record Source statement - work fine:
展开 | 选择 | 换行 | 行号


在任何涉及的表中是否有一个具有位类型的字段?如果是这样,则必须将其设置为不允许空值。如果你这样做,它会让你第一次输入记录,但如果你把那个字段留空,它就不会让你编辑那条记录。我所做的是将我的复选框设置为默认值为False,以便所有新记录都传递一个false值(除非我将其更改为True)然后我的问题就消失了。
Is there a field in any of the involved tables that has a bit type? If so, you must have it set to not allow null values. If you do, it will let you enter the record the first time fine, but then it won''t ever let you edit that record if you left that field null. What I do is to set my checkboxes to have a default value of False so that all new records pass a false value (unless I change it to True) and then my issue goes away.