数据已更改。另一位用户在您尝试保存更改之前编辑了此记录并保存了更改。重新编辑记录 [英] The data has been changed. Another user edited this record and saved the changes before you attempted to save your changes. Re-edit the record

问题描述

大家好，


我在Access中有一个表单和VB代码。代码就像是

随着rs

。编辑

！Field = 10

。更新

结束


当我在表单上更改值时。然后出现错误。


数据已更改。另一位用户在您尝试保存更改之前编辑了此记录并保存了更改。重新编辑

记录


任何人都知道是什么原因引起的？在此先感谢。

Hi All,

I have a form and VB code in Access. The code is like
With rs
.Edit
!Field = 10
.Update
End With

When I chang a value on the form. then the error shows up.

The data has been changed. Another user edited this record and saved
the changes before you attempted to save your changes. Re-edit the
record

Anyone has idea what cause that? Thanks in advance.

推荐答案

在大多数情况下，我看到，如果您有两个子表格或

表单链接到同一个表。如果您尝试从

不同的表单编辑表格，而第二个表格/ subfrm（链接到同一个表格）

已打开。在这段代码运行的时候，我会检查你是否有相应的表

已经打开。

daniel写道：

In most cases, I have seen, this happens, if you have two subforms or
forms linked to the same table. If you try to edit the table from a
different form while the second form/subfrm (linked to the same table)
is open. I would check to see if you have the corresponding table
already open while this piece of code is running.
daniel wrote:

大家好，

我在Access中有一个表单和VB代码。代码就像

用rs
。编辑
！Field = 10
。更新
结束用

当我改变表格上的价值。然后出现错误。

数据已被更改。另一位用户在您尝试保存更改之前编辑了此记录并保存了更改。重新编辑


任何人都知道是什么原因引起的？在此先感谢。

Hi All,

I have a form and VB code in Access. The code is like
With rs
.Edit
!Field = 10
.Update
End With

When I chang a value on the form. then the error shows up.

The data has been changed. Another user edited this record and saved
the changes before you attempted to save your changes. Re-edit the
record

Anyone has idea what cause that? Thanks in advance.

我只有一个主表格。

I only have one main form.

SQL Server中的数据是否有任何备注字段？


-


Danny J. Lesandrini dl*********@hotmail.com
http://amazecreations.com/datafast

" daniel" <哒******* @ gmail.com>写道......

Is the data in SQL Server and do you have any memo fields?

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"daniel" <da*******@gmail.com> wrote...

我只有一个主要表格。

这篇关于数据已更改。另一位用户在您尝试保存更改之前编辑了此记录并保存了更改。重新编辑记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！