其他用户更新的数据 [英] Data Being Updated by Another User
问题描述
我一直收到这个错误：
Microsoft Jet数据库引擎停止了这个过程，因为你和另外一个用户正在尝试更改相同数据的
同时。
没有其他用户。我已经尝试将表格移动到另一个数据库，通过
导入，导出和复制/粘贴。我已经尝试了一个Make-a-new-table
查询。我试过在同一个数据库中复制/粘贴表格。
我可以将该表和另一个表放在一个选择的查询中，只要我
没有指定任何标准，如果我这样做，我会收到错误。
我唯一可以猜到的可能是因为我把它放在了
跳转驱动器上的
数据库，然后将其拉出插座，而不执行删除硬件的工作。
有没有办法撤消这个？
谢谢！ JA
您是如何尝试更新数据的？你的
应用程序中打开了哪些对象？
有没有办法撤消这个？
很难根据你发布的内容说出来。这不是因为你没有&b $ b删除硬件。当多个进程发生时，Jet会返回错误
尝试一次编辑同一条记录。没有必要两个
单独的用户。
通常的原因是我的开放时间的组合
尝试在代码中执行记录集更新...但是任何事情都可能是因为这导致了这个问题。你有更多的细节吗？
Rick和Bill，
我在一个查询中有2个表，并且当我指定要查找的标准时，我将会收到错误 - 查询无法打开。
另外，当我试图复制时表（给出了错误），或者打开或关闭
，我会得到错误。
我没有足够的天赋去做任何代码！ :-)
但是，我只是压缩和修复，现在看起来还可以......
嗯，我压缩和修理了，现在没关系。
" BillCo" <共********** @ gmail.com>在消息中写道
news：11 ********************* @ u72g2000cwu.googlegro ups.com ...有没有办法撤消这个？
根据你发布的内容很难说。这不是因为你没有移除硬件。当多个进程尝试一次编辑同一记录时，Jet会返回该错误。不必有两个单独的用户。
对我而言，通常的原因是在尝试在代码中执行记录集更新时打开绑定的组合......但是任何事情都可能导致这种情况。你有更多细节吗？
I keep getting this error:
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time.
There is no other user. I''ve tried moving the table to another database, by
importing, exporting, and by copy/pasting. I''ve tried a Make-a-new-table
query. I''ve tried copy/pasting the table within the same database.
I can put that table and another together in a select query, as long as I
don''t specify any criteria, if I do, I get the error.
The only thing I can guess that might have caused this is that I put the
database on a jump drive and then pulled it out of its socket without doing
the Remove Hardware stuff.
Is there a way to undo this?
Thanks! JA
How are you attempting to update the data? What objects are open in your
application?
Is there a way to undo this?
very hard to say based on what you''ve posted. it''s not cause you didn''t
remove the hardware. Jet returns that error when more than one process
attempts to edit the same record at once. There doesnt have to be two
seperate "users".
the usual cause for me is a combination of a bound for open while
trying to perform a recordset update in code... but anything could be
causing this. do you have more details?
Rick and Bill,
I had 2 tables in a query, and when I would specify criteria to look for, I
would get the error - the query wouldn''t open.
Also, when I tried to copy the table (that was giving the error), either
open or closed, I would get the error.
I''m not talented enough to do anything in code! :-)
But, I just Compacted and Repaired, and now it seems to be ok......
Well, I compacted and repaired, and now it is ok.
"BillCo" <co**********@gmail.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...Is there a way to undo this?
very hard to say based on what you''ve posted. it''s not cause you didn''t
remove the hardware. Jet returns that error when more than one process
attempts to edit the same record at once. There doesnt have to be two
seperate "users".
the usual cause for me is a combination of a bound for open while
trying to perform a recordset update in code... but anything could be
causing this. do you have more details?
这篇关于其他用户更新的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
