“您和其他用户......” - 标准修订不适用 [英] "you and another user..."--standard fixes don't apply
问题描述
嗨：
这是我长期以来遇到的一个问题。客户真的是在耐心地运行
，我没有答案。
Access2003，前端和后端。
包含4个子表单的单个表单（每个表示一个相关表），5-10
职员一次进行数据输入。表格非常大但是所有
工作都是使用未绑定的表单和/或本地临时表完成的，并且每隔一段时间写回服务器（我移到了该结构中）希望
解决这个问题;它似乎无法提供帮助）。
错误是3197，Microsoft Jet数据库引擎停止了
流程，因为您和其他用户正试图在相同的
时间内更改相同的
数据。
它通常发生在一个特定的子表单上，但有时发生在
另一个子表单上。我相信它发生在将记录回写到服务器上的主数据库（来自本地临时表）的点上。
客户端在加利福尼亚州我在芝加哥所以我不能看他们
工作。他们不会让我有能力登录他们的个人工作站进行故障排除。我无法重现这个问题，无论是在我的计算机上，还是在我可以远程访问的计算机上。
我搜索过了这个问题并查看了所有提议的原因，并且
它们都不适用。
没有备注字段。
我已经压缩，重建了表格，将所有数据写入了新的表格上，我认为没有数据损坏。
这种错误间歇性地发生。他们可以花几天时间没有错误
然后将它们放在每两三个记录中几天。
我相信大多数职员都会得到错误但有些人不会，或者有些人不太经常这样做。
他们的服务器曾经非常缓慢;它现在好一点了。
我很想把它归咎于他们的网络连接，但没有坚实的证据他们的IT人员不会接受这个作为答案。
我们正在努力转向SQL Server后端。我想
认为这样可以解决问题，但如果它没有我遇到的麻烦。
我有不知道如何解决这个问题。
有人可以帮忙吗？
我很乐意付钱让别人把这件东西拆开找到这个缺陷。
我自己肯定看不到。
谢谢。
Jan
" Jan" < ja*@dontspamme.com在留言中写道
新闻：ST ******************* @ en-nntp-08.dc1.easynews .com ...
嗨：
这是我长期以来遇到的一个问题。客户真的是在耐心地运行
，我没有答案。
Access2003，前端和后端。
包含4个子表单的单个表单（每个表示一个相关表），5-10
职员一次进行数据输入。表格非常大但是所有
工作都是使用未绑定的表单和/或本地临时表完成的，并且每隔一段时间写回服务器（我移到了该结构中）希望
解决这个问题;它似乎无法提供帮助）。
错误是3197，Microsoft Jet数据库引擎停止了
流程，因为您和其他用户正试图在相同的
时间内更改相同的
数据。
它通常发生在一个特定的子表单上，但有时发生在
另一个子表单上。我相信它发生在将记录回写到服务器上的主数据库（来自本地临时表）的点上。
客户端在加利福尼亚州我在芝加哥所以我不能看他们
工作。他们不会让我有能力登录他们的个人工作站进行故障排除。我无法重现这个问题，无论是在我的计算机上，还是在我可以远程访问的计算机上。
我搜索过了这个问题并查看了所有提议的原因，并且
它们都不适用。
没有备注字段。
我已经压缩，重建了表格，将所有数据写入了新的表格上，我认为没有数据损坏。
这种错误间歇性地发生。他们可以花几天时间没有错误
然后将它们放在每两三个记录中几天。
我相信大多数职员都会得到错误但有些人不会，或者有些人不太经常这样做。
他们的服务器曾经非常缓慢;它现在好一点了。
我很想把它归咎于他们的网络连接，但没有坚实的证据他们的IT人员不会接受这个作为答案。
我们正在努力转向SQL Server后端。我想
认为这样可以解决问题，但如果它没有我遇到的麻烦。
我有不知道如何解决这个问题。
有人可以帮忙吗？
我很乐意付钱让别人把这件东西拆开找到这个瑕疵。
我自己肯定看不到。
谢谢。
Jan
您的用途是否有前端的单独副本或是否共享？
您是否尝试过粘贴该错误消息进入谷歌？
他们有单独的副本。我确实将错误粘贴到谷歌并得到了一些新的信息，但并不多：主要是那些在没有解决方案的情况下撕裂他们的头发的人。我见过的唯一的解决办法是试图做一个简短的睡眠工作。然后重试。
任何想法？
paii，Ron写道：
" Jan" < ja*@dontspamme.com在留言中写道
新闻：ST ******************* @ en-nntp-08.dc1.easynews .com ...
>嗨：
这是我长期以来遇到的一个问题。客户真的没有耐心了，而且我没有答案。
Access2003，前端和后端。
单一形式有4个子表格（每个代表一个相关的表），5-10
职员一次进行数据输入。表格非常大但是所有的工作都是使用未绑定的表单和/或本地临时表完成的，并且每隔一段时间写回服务器（我转移到了希望解决的结构中）这个问题;它似乎没有帮助。
错误是3197，Microsoft Jet数据库引擎停止了
进程，因为您和另一个用户正在尝试更改相同的
数据在同一时间。
它通常发生在一个特定的子表单上，但有时会发生在另一个子表单上。我相信它发生在将记录写回服务器上的主数据库（来自本地临时表）的位置。
客户端在加利福尼亚，我在芝加哥所以我不能看他们工作。他们不会让我有能力登录他们的个人工作站进行故障排除。我无法在这里的计算机上或者我可以远程访问的计算机上重现这个问题。
我已经搜索了这个问题并查看了所有建议原因，并且
没有一个适用。
没有备忘录字段。
我已经压缩，重建表格，将所有数据写入新表格
a清理空白数据库，我相信没有数据损坏。
这种错误间歇性地发生。他们可以走几天没有任何错误
然后将它们放在每两三个记录中几天。
我相信大部分职员都会得到错误，但有些人不会，或者有些人不那么经常使用它们。
他们的服务器曾经非常缓慢;它现在好一点了。
我很想把它归咎于他们的网络连接，但没有坚实的证据表明他们的IT人员不会接受这个答案。
我们正在努力转向SQL Server后端。我想认为这样可以解决问题，但如果它没有我遇到的麻烦。
我不知道如何解决这个问题。
有人可以帮忙吗？
我很乐意付钱给别人把这个东西拆开来找到这个缺陷。
我肯定看不到它我自己。
谢谢。
Jan
您的用途是否有单独的前端副本或是他们分享了吗？
您是否尝试将该错误消息粘贴到Google？
Jan写道：
嗨：
这是我长期以来遇到的一个问题。客户真的是在耐心地运行
，我没有答案。
Access2003，前端和后端。
包含4个子表单的单个表单（每个表示一个相关表），5-10
职员一次进行数据输入。表格非常大但是所有
工作都是使用未绑定的表单和/或本地临时表完成的，并且每隔一段时间写回服务器（我移到了该结构中）希望
解决这个问题;它似乎无法提供帮助）。
错误是3197，Microsoft Jet数据库引擎停止了
流程，因为您和其他用户正试图在相同的
时间内更改相同的
数据。
它通常发生在一个特定的子表单上，但有时发生在
另一个子表单上。我相信它发生在将记录回写到服务器上的主数据库（来自本地临时表）的点上。
客户端在加利福尼亚州我在芝加哥所以我不能看他们
工作。他们不会让我有能力登录他们的个人工作站进行故障排除。我无法重现这个问题，无论是在我的计算机上，还是在我可以远程访问的计算机上。
我搜索过了这个问题并查看了所有提议的原因，并且
它们都不适用。
没有备注字段。
我已经压缩，重建了表格，将所有数据写入了新的表格上，我认为没有数据损坏。
这种错误间歇性地发生。他们可以花几天时间没有错误
然后将它们放在每两三个记录中几天。
我相信大多数职员都会得到错误但有些人不会，或者有些人不太经常这样做。
他们的服务器曾经非常缓慢;它现在好一点了。我希望b $ b喜欢把它归咎于他们的网络连接，但没有坚实的证据，他们的IT员工不会接受这个答案。
我们正在努力转向SQL Server后端。我想
认为这样可以解决问题，但如果它没有我遇到的麻烦。
我有不知道如何解决这个问题。
有人可以帮忙吗？
我很乐意付钱让别人把这件东西拆开找到这个瑕疵。
我自己肯定看不到。
谢谢。
Jan
你有任何代码，主要或子形式，形式为'AfterUpdate它
更新任何表或运行动作查询？
特定的人是否能解决问题？这可能是他们没有抓住的东西......因为你可能会以某种方式对它进行测试
但是用户做了不同的事情或者用户以不同的方式输入内容
。
您是否知道错误何时发生？什么代码行，什么
事件会触发问题？
它们是运行完整版本的Access而不是运行时吗？您可以
搜索On Err并用''On Err替换问题表单代码
（不要在On Error Resume Next或On Error GoTo上执行此操作0'）所以代码
可以进入Debug？
在你的错误信息中你是否有它打破的例程。例如：
Msgbox Err.Description ,,Form_AfterUpdate
这样你就可以知道消息来自哪里了？
Hi:
Here''s a problem I''ve had for a long time. The client is really running
out of patience, and I have no answers.
Access2003, front- and back-end.
Single form with 4 subforms (each representing a related table), 5-10
clerks doing data entry at one time. Tables are quite large but all
work is done with unbound forms and/or local temp tables, and written
back to the server at intervals (I moved to that structure in the hopes
of solving this problem; it didn''t seem to help).
The error is 3197, "The Microsoft Jet database engine stopped the
process because you and another user are attempting to change the same
data at the same
time."
It generally happens on one particular subform, but sometimes happens on
another one. I believe it happens at the point at which the record is
written back to the main db on the server (from the local temp tables).
The client is in California and I''m in Chicago so I can''t watch them
work. They won''t give me the ability to log onto their individual
workstations to troubleshoot. I can''t reproduce the problem, either on
my computer here, or on the computer to which I do have remote access.
I have searched this problem and looked at all the proposed causes, and
none of them applies.
There are no Memo fields.
I have compacted, rebuilt the tables, written all data to new tables on
a clean blank database, I believe there is no data corruption.
This error occurs intermittently. They can go a few days with no errors
but then have them on every two or three records for a few days.
I believe that most of the clerks get the errors but that some don''t, or
some get them less often.
Their server used to be horrendously slow; it''s now somewhat better.
I''d love to blame it on their network connections, but without solid
evidence their IT staff is not going to accept that as an answer.
We are working toward switching to a SQL Server back-end. I''d like to
think that will solve the problem, but if it doesn''t I''m in deep trouble.
I have no idea how to fix this.
Can someone help?
I''d be happy to pay someone to take this thing apart and find the flaw.
I sure can''t see it myself.
Thanks.
Jan
"Jan" <ja*@dontspamme.comwrote in message
news:ST*******************@en-nntp-08.dc1.easynews.com...Hi:
Here''s a problem I''ve had for a long time. The client is really running
out of patience, and I have no answers.
Access2003, front- and back-end.
Single form with 4 subforms (each representing a related table), 5-10
clerks doing data entry at one time. Tables are quite large but all
work is done with unbound forms and/or local temp tables, and written
back to the server at intervals (I moved to that structure in the hopes
of solving this problem; it didn''t seem to help).
The error is 3197, "The Microsoft Jet database engine stopped the
process because you and another user are attempting to change the same
data at the same
time."
It generally happens on one particular subform, but sometimes happens on
another one. I believe it happens at the point at which the record is
written back to the main db on the server (from the local temp tables).
The client is in California and I''m in Chicago so I can''t watch them
work. They won''t give me the ability to log onto their individual
workstations to troubleshoot. I can''t reproduce the problem, either on
my computer here, or on the computer to which I do have remote access.
I have searched this problem and looked at all the proposed causes, and
none of them applies.
There are no Memo fields.
I have compacted, rebuilt the tables, written all data to new tables on
a clean blank database, I believe there is no data corruption.
This error occurs intermittently. They can go a few days with no errors
but then have them on every two or three records for a few days.
I believe that most of the clerks get the errors but that some don''t, or
some get them less often.
Their server used to be horrendously slow; it''s now somewhat better.
I''d love to blame it on their network connections, but without solid
evidence their IT staff is not going to accept that as an answer.
We are working toward switching to a SQL Server back-end. I''d like to
think that will solve the problem, but if it doesn''t I''m in deep trouble.
I have no idea how to fix this.
Can someone help?
I''d be happy to pay someone to take this thing apart and find the flaw.
I sure can''t see it myself.
Thanks.
JanDo your uses have separate copies of the front-end or are they sharing?
Have you tried pasting that error message into Google?
They have separate copies. I did paste the error into Google and got a
bit of new info but not much: mainly people who are tearing their hair
out over this error with no solution. The only work-arounds I''ve seen
are trying to do a brief "sleep" and then retry.
Any ideas?
paii, Ron wrote:"Jan" <ja*@dontspamme.comwrote in message
news:ST*******************@en-nntp-08.dc1.easynews.com...>Hi:
Here''s a problem I''ve had for a long time. The client is really running
out of patience, and I have no answers.
Access2003, front- and back-end.
Single form with 4 subforms (each representing a related table), 5-10
clerks doing data entry at one time. Tables are quite large but all
work is done with unbound forms and/or local temp tables, and written
back to the server at intervals (I moved to that structure in the hopes
of solving this problem; it didn''t seem to help).
The error is 3197, "The Microsoft Jet database engine stopped the
process because you and another user are attempting to change the same
data at the same
time."
It generally happens on one particular subform, but sometimes happens on
another one. I believe it happens at the point at which the record is
written back to the main db on the server (from the local temp tables).
The client is in California and I''m in Chicago so I can''t watch them
work. They won''t give me the ability to log onto their individual
workstations to troubleshoot. I can''t reproduce the problem, either on
my computer here, or on the computer to which I do have remote access.
I have searched this problem and looked at all the proposed causes, and
none of them applies.
There are no Memo fields.
I have compacted, rebuilt the tables, written all data to new tables on
a clean blank database, I believe there is no data corruption.
This error occurs intermittently. They can go a few days with no errors
but then have them on every two or three records for a few days.
I believe that most of the clerks get the errors but that some don''t, or
some get them less often.
Their server used to be horrendously slow; it''s now somewhat better.
I''d love to blame it on their network connections, but without solid
evidence their IT staff is not going to accept that as an answer.
We are working toward switching to a SQL Server back-end. I''d like to
think that will solve the problem, but if it doesn''t I''m in deep trouble.
I have no idea how to fix this.
Can someone help?
I''d be happy to pay someone to take this thing apart and find the flaw.
I sure can''t see it myself.
Thanks.
Jan
Do your uses have separate copies of the front-end or are they sharing?
Have you tried pasting that error message into Google?
Jan wrote:
Hi:
Here''s a problem I''ve had for a long time. The client is really running
out of patience, and I have no answers.
Access2003, front- and back-end.
Single form with 4 subforms (each representing a related table), 5-10
clerks doing data entry at one time. Tables are quite large but all
work is done with unbound forms and/or local temp tables, and written
back to the server at intervals (I moved to that structure in the hopes
of solving this problem; it didn''t seem to help).
The error is 3197, "The Microsoft Jet database engine stopped the
process because you and another user are attempting to change the same
data at the same
time."
It generally happens on one particular subform, but sometimes happens on
another one. I believe it happens at the point at which the record is
written back to the main db on the server (from the local temp tables).
The client is in California and I''m in Chicago so I can''t watch them
work. They won''t give me the ability to log onto their individual
workstations to troubleshoot. I can''t reproduce the problem, either on
my computer here, or on the computer to which I do have remote access.
I have searched this problem and looked at all the proposed causes, and
none of them applies.
There are no Memo fields.
I have compacted, rebuilt the tables, written all data to new tables on
a clean blank database, I believe there is no data corruption.
This error occurs intermittently. They can go a few days with no errors
but then have them on every two or three records for a few days.
I believe that most of the clerks get the errors but that some don''t, or
some get them less often.
Their server used to be horrendously slow; it''s now somewhat better. I''d
love to blame it on their network connections, but without solid
evidence their IT staff is not going to accept that as an answer.
We are working toward switching to a SQL Server back-end. I''d like to
think that will solve the problem, but if it doesn''t I''m in deep trouble.
I have no idea how to fix this.
Can someone help?
I''d be happy to pay someone to take this thing apart and find the flaw.
I sure can''t see it myself.
Thanks.
JanDo you have any code, main or subform, that in the form''s AfterUpdate it
updates any tables or runs an action query?
Is it a specific person that gets the problem? It may be something they
do that you aren''t trapping for...as in you might test it a certain way
but the user does something differently or the user enters something
differently than you.
Do you have any idea when the error occurs? What line of code, what
event triggers the problem?
Are they running a full version of Access and not a runtime? You could
search for On Err and replace with ''On Err for the problem forms code
(don''t do that on On Error Resume Next or On Error GoTo 0''s) so the code
can get into Debug?
In your error message do you have the routine it breaks on. Ex:
Msgbox Err.Description,,"Form_AfterUpdate"
so you get an idea where the message is coming from?
这篇关于“您和其他用户......” - 标准修订不适用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
