错误3197但没有备注字段 [英] Error 3197 but there are no memo fields
问题描述
嗨：
我有错误3197问题（Microsoft Jet数据库引擎
停止了这个过程，因为你和另一个用户正在尝试在客户端数据库中同时更改相同的数据。它大约一个月前开始出现并且变得越来越糟。
我在搜索这个主题时看到的回复谈论腐败，但此数据库中没有这些。我b $ b拿了后端的副本，进行了紧凑/修复，打开了每张桌子，并且
搜索了损坏的字段，甚至按照每个表中的每个字段排序，
如果出现腐败通常会出现问题，什么也没发现。
我也无法在办公室重现这个问题。事实上它是客户'间歇性的
。一个用户得到了很多，几乎可以按需要产生
，而其他用户只是偶尔得到它。我看着它出现了b $ b，试图跟踪它，但是无法捕捉到正在发生的事情。
错误似乎独立于任何键盘动作而传播;
之后的初始错误，我正坐在那里试图弄清楚在哪里看
看起来错误就会一次又一次地弹出，即使我是
没有碰到屏幕（系统上没有其他人在那个
时刻）。
这可能与此有关Access的版本？我在A97开发并且
转换为交付。我办公室里有A97和AXP;客户
有A2000（SP-3）。他们根本没有互联网接入（不要问......）
因此他们无法下载补丁等;他们依赖于IT员工
有时会在几天内做出反应但是不一致。
这可能与它有关防毒软件？ （我正在抓住吸管
这里，但事实上它似乎独立于键盘动作
让我感到疑惑）。他们运行了McAfee VirusScan Enterprise 8.0.0。
仅供参考，大多数时间有3-5个用户登录，他们（当然）
分享一个后端但每个都有一个前端副本在他们的c：驱动器上。
任何建议，要寻找的东西等等？
Jan
" Jan" < ja*@dontspamme.com在留言中写道
新闻：12 ************* @ corp.supernews.com ...
嗨：
我有错误3197问题（Microsoft Jet数据库引擎
停止了进程，因为您和另一个用户正在尝试在客户端数据库中同时更改相同的数据。它大约一个月前开始出现并且变得越来越糟。
我在搜索这个主题时看到的回复谈论腐败，但此数据库中没有这些。我b $ b拿了后端的副本，进行了紧凑/修复，打开了每张桌子，并且
搜索了损坏的字段，甚至按照每个表中的每个字段排序，
如果出现腐败通常会出现问题，什么也没发现。
我也无法在办公室重现这个问题。事实上它是客户'间歇性的
。一个用户得到了很多，几乎可以按需要产生
，而其他用户只是偶尔得到它。我看着它出现了b $ b，试图跟踪它，但是无法捕捉到正在发生的事情。
错误似乎独立于任何键盘动作而传播;
之后的初始错误，我正坐在那里试图弄清楚在哪里看
看起来错误就会一次又一次地弹出，即使我是
没有碰到屏幕（系统上没有其他人在那个
时刻）。
这可能与此有关Access的版本？我在A97开发并且
转换为交付。我办公室里有A97和AXP;客户
有A2000（SP-3）。他们根本没有互联网接入（不要问......）
因此他们无法下载补丁等;他们依赖于IT员工
有时会在几天内做出反应但是不一致。
这可能与它有关防毒软件？ （我正在抓住吸管
这里，但事实上它似乎独立于键盘动作
让我感到疑惑）。他们运行了McAfee VirusScan Enterprise 8.0.0。
仅供参考，大多数时间有3-5个用户登录，他们（当然）
分享一个后端，但每个都有一个前端副本在他们的c：驱动器上。
任何建议，要寻找的东西等等？
这可能过于简单了但是我知道这两件事已经造成了麻烦。
1）你如何交付？如果它是由记忆棒/ USB驱动器等，请尝试通过CD。
2）他们的野兽是否关闭了自动更正？
-
Sharktbbtfy
On Tue，2006年11月7日16:01:11 -0600，Jan< ja *@dontspamme.com写道：
我知道这将是一场战斗，但客户应该知道，现在你不能期望有一个功能不是最新的应用程序
补丁。至少为他们安装Jet 4.0 SP8。你只是不想
追逐已在服务包中修复的问题。事实上，我们写了启动代码来检查Jet的最低级别和
访问权限，并且如果找不到则拒绝运行。
面对顽固的客户，我们很乐意将他们留给我们的
竞争对手。
我们有MacAfee公司版，并且没有看到干扰
访问数据库。
-Tom。
>嗨：<我有错误3197问题（Microsoft Jet数据库引擎停止了该过程，因为您和另一个用户正试图在同一时间更改相同的数据客户端数据库中的时间。。它大约在一个月前开始出现并且变得越来越糟。
我在搜索这个主题时看到的回复在备忘录或OLE字段中谈论腐败
但是这个数据库中没有这些。我拿了后端的副本，做了紧凑/修复，打开了每张桌子并搜索了腐败的字段，甚至在每张桌子的每个字段上排序，
这通常会出现问题，如果有腐败，一无所获。
我也无法在办公室里重现这个问题，实际上它在客户端是间歇性的。 。一个用户可以获得很多，并且几乎可以按需生成它，而其他用户只是偶尔获得它。我看着它出现了，试图追踪它，但无法捕捉到正在发生的事情。
错误似乎独立于任何键盘动作而传播;在最初的错误之后，我正坐在那里试图弄清楚在哪里看，错误会一次又一次地弹出，即使我没有触摸屏幕（和在那个
时刻没有其他人在系统上。
这可能与Access的版本有关吗？我在A97开发并转换为交付。我办公室里有A97和AXP;客户
有A2000（SP-3）。他们根本没有互联网接入（不要问......）
所以他们不能下载补丁等;他们依赖于IT员工，有时候会在几天内做出反应，但是并不一致。
这可能与防病毒软件有关吗？ （我正在抓住吸管
这里，但事实上它似乎独立于键盘动作
让我感到疑惑）。他们正在运行McAfee VirusScan Enterprise 8.0.0。
仅供参考，大多数时间有3-5个用户登录，他们（当然）共享后端但每个用户都有一个c：驱动器前端的副本。
任何建议，要寻找的东西等等？
Jan
你认为这可能是一个补丁问题吗？或者他们应该转到不同版本的Access吗？有没有人在
这个上下文中看到过这个问题？
我的客户端实际上对补丁等概念很好，但她的
项目位于芝加哥市的一部分办公室
，而且该市的IT部门只是过载而且速度很慢。
谢谢。
Jan
Tom van Stiphout写道：
On Tue ，2006年11月7日16:01:11 -0600，Jan< ja*@dontspamme.comwrote：
我知道这将是一场战斗，但客户应该知道现在你
不能期望有一个正常运行的应用程序，而不是最新的
补丁。至少为他们安装Jet 4.0 SP8。您只是不希望
来追查已在服务包中修复的问题。作为一个事实，我们编写启动代码来检查最低水平的
Jet和Access，如果没有找到则拒绝运行。
面对顽固的客户，我们很乐意将他们留给我们的
竞争对手。
我们有MacAfee公司版，并且没有看到干扰
与Access数据库。
-Tom。
>嗨：<我有错误3197问题（Microsoft Jet数据库引擎停止了该过程，因为您和另一个用户正试图在同一时间更改相同的数据客户端数据库中的时间。。它大约在一个月前开始出现，并且变得更糟，更糟糕。
我在搜索这个主题时看到的回复谈到备忘录中的腐败或OLE字段，但这个数据库中没有这些。我拿了后端的副本，做了紧凑/修复，打开了每张桌子并搜索了腐败的字段，甚至在每张桌子的每个字段上排序，这通常会出现问题，如果
有腐败，一无所获。
我也无法在我的办公室重现这个问题，事实上它在客户端是间歇性的。一个用户得到它很多，并且可以按需几乎产生它，而其他用户只是偶尔得到它。
我看着它出现，试图追踪它，但是无法抓住
发生了什么事。错误似乎独立于任何键盘动作传播;在最初的错误之后，我正坐在那里
试图弄清楚在哪里看，错误会一次又一次地弹出，即使我没有触摸屏幕（并且没有当时其他人在系统上。）
这可能与Access的版本有关吗？我在A97开发
并转换为交付。我的办公室里有A97和AXP;
客户端有A2000（SP-3）。他们没有互联网访问所有（不要问......）所以他们不能下载补丁等;他们依赖于IT人员，他们有时会在几天内做出响应但是不一致。
它是否与防病毒软件有关？ （我在这里抓住吸管，但事实上它似乎独立于键盘动作而让我感到疑惑）。他们运行了McAfee VirusScan
Enterprise 8.0.0。仅供参考，大多数时间有3-5个用户登录，他们（
当然）共享后端但每个都有一个前端的副本在他们的c：驱动器上。
任何建议，要寻找的东西等等。
Jan
Hi:
I''ve got the Error 3197 problem ("The Microsoft Jet database engine
stopped the process because you and another user are attempting to
change the same data at the same time.") in a client database. It
started appearing about a month ago and has gotten worse and worse.
The responses I saw when I searched on this topic talk about corruption
in a memo or OLE field, but there are none of those in this database. I
took a copy of the backend, did compact/repair, opened each table and
searched for corrupt fields, even sorted on each field in each table,
which usually turns up a problem if there''s corruption, and found nothing.
I also can''t reproduce the problem here at my office, and in fact it''s
intermittent at the client''s. One user gets it a lot and can almost
produce it on demand, while others get it only occasionally. I watched
it appear, tried to track it down, but couldn''t catch what was going on.
The error seems to propagate independent of any keyboard action; after
the initial error, I was sitting there trying to figure out where to
look and the error would just pop up again and again even though I
wasn''t touching the screen (and no one else was on the system at that
moment).
Could this have to do with versions of Access? I develop in A97 and
convert for delivery. I have A97 and AXP here at my office; the client
has A2000 (SP-3). They don''t have internet access at all (don''t ask...)
so they can''t download patches, etc; they''re dependent on an IT staff
that sometimes responds in a couple of days but isn''t consistent.
Could it have to do with anti-virus software? (I''m grasping at straws
here, but the fact that it seems to occur independent of keyboard action
gets me wondering). They have McAfee VirusScan Enterprise 8.0.0 running.
FYI, there are 3-5 users logged on at most times, and they (of course)
share a back end but each have a copy of the front end on their c: drive.
Any recommendations, things to look for, etc.?
Jan
"Jan" <ja*@dontspamme.comwrote in message
news:12*************@corp.supernews.com...Hi:
I''ve got the Error 3197 problem ("The Microsoft Jet database engine
stopped the process because you and another user are attempting to
change the same data at the same time.") in a client database. It
started appearing about a month ago and has gotten worse and worse.
The responses I saw when I searched on this topic talk about corruption
in a memo or OLE field, but there are none of those in this database. I
took a copy of the backend, did compact/repair, opened each table and
searched for corrupt fields, even sorted on each field in each table,
which usually turns up a problem if there''s corruption, and found nothing.
I also can''t reproduce the problem here at my office, and in fact it''s
intermittent at the client''s. One user gets it a lot and can almost
produce it on demand, while others get it only occasionally. I watched
it appear, tried to track it down, but couldn''t catch what was going on.
The error seems to propagate independent of any keyboard action; after
the initial error, I was sitting there trying to figure out where to
look and the error would just pop up again and again even though I
wasn''t touching the screen (and no one else was on the system at that
moment).
Could this have to do with versions of Access? I develop in A97 and
convert for delivery. I have A97 and AXP here at my office; the client
has A2000 (SP-3). They don''t have internet access at all (don''t ask...)
so they can''t download patches, etc; they''re dependent on an IT staff
that sometimes responds in a couple of days but isn''t consistent.
Could it have to do with anti-virus software? (I''m grasping at straws
here, but the fact that it seems to occur independent of keyboard action
gets me wondering). They have McAfee VirusScan Enterprise 8.0.0 running.
FYI, there are 3-5 users logged on at most times, and they (of course)
share a back end but each have a copy of the front end on their c: drive.
Any recommendations, things to look for, etc.?This might be too simplistic but here''s two things that I know have caused
trouble.
1) How do you deliver? If it''s by Memory stick/USB Drive,etc, try by CD.
2) Is autocorrect turned off on their beasts?
--
Sharktbbtfy
On Tue, 07 Nov 2006 16:01:11 -0600, Jan <ja*@dontspamme.comwrote:
I know it will be a battle, but client should know that nowadays you
can''t expect to have a functioning app without being current on
patches. AT LEAST install Jet 4.0 SP8 for them. You just don''t want to
chase down issues that have been fixed in a service pack. As a matter
of fact we write startup code to check for minimum levels of Jet and
Access, and refuse to run if not found.
Confronted with stubborn clients we gladly leave them to our
competitors.
We have MacAfee Corporate edition, and have not seen interference with
Access databases.
-Tom.
>Hi:
I''ve got the Error 3197 problem ("The Microsoft Jet database engine
stopped the process because you and another user are attempting to
change the same data at the same time.") in a client database. It
started appearing about a month ago and has gotten worse and worse.
The responses I saw when I searched on this topic talk about corruption
in a memo or OLE field, but there are none of those in this database. I
took a copy of the backend, did compact/repair, opened each table and
searched for corrupt fields, even sorted on each field in each table,
which usually turns up a problem if there''s corruption, and found nothing.
I also can''t reproduce the problem here at my office, and in fact it''s
intermittent at the client''s. One user gets it a lot and can almost
produce it on demand, while others get it only occasionally. I watched
it appear, tried to track it down, but couldn''t catch what was going on.
The error seems to propagate independent of any keyboard action; after
the initial error, I was sitting there trying to figure out where to
look and the error would just pop up again and again even though I
wasn''t touching the screen (and no one else was on the system at that
moment).
Could this have to do with versions of Access? I develop in A97 and
convert for delivery. I have A97 and AXP here at my office; the client
has A2000 (SP-3). They don''t have internet access at all (don''t ask...)
so they can''t download patches, etc; they''re dependent on an IT staff
that sometimes responds in a couple of days but isn''t consistent.
Could it have to do with anti-virus software? (I''m grasping at straws
here, but the fact that it seems to occur independent of keyboard action
gets me wondering). They have McAfee VirusScan Enterprise 8.0.0 running.
FYI, there are 3-5 users logged on at most times, and they (of course)
share a back end but each have a copy of the front end on their c: drive.
Any recommendations, things to look for, etc.?
Jan
So do you think that this could be an issue of patches? Or should they
go to a different version of Access? Has anyone seen this problem in
this context?
My client is actually fine with the concept of patches etc, but her
program is in an office that''s part of the City of Chicago
and the city''s IT dept is just overloaded and slow.
Thanks.
Jan
Tom van Stiphout wrote:On Tue, 07 Nov 2006 16:01:11 -0600, Jan <ja*@dontspamme.comwrote:
I know it will be a battle, but client should know that nowadays you
can''t expect to have a functioning app without being current on
patches. AT LEAST install Jet 4.0 SP8 for them. You just don''t want
to chase down issues that have been fixed in a service pack. As a
matter of fact we write startup code to check for minimum levels of
Jet and Access, and refuse to run if not found.
Confronted with stubborn clients we gladly leave them to our
competitors.
We have MacAfee Corporate edition, and have not seen interference
with Access databases.
-Tom.
>Hi:
I''ve got the Error 3197 problem ("The Microsoft Jet database engine
stopped the process because you and another user are attempting to
change the same data at the same time.") in a client database. It
started appearing about a month ago and has gotten worse and
worse.
The responses I saw when I searched on this topic talk about
corruption in a memo or OLE field, but there are none of those in
this database. I took a copy of the backend, did compact/repair,
opened each table and searched for corrupt fields, even sorted on
each field in each table, which usually turns up a problem if
there''s corruption, and found nothing.
I also can''t reproduce the problem here at my office, and in fact
it''s intermittent at the client''s. One user gets it a lot and can
almost produce it on demand, while others get it only occasionally.
I watched it appear, tried to track it down, but couldn''t catch
what was going on. The error seems to propagate independent of any
keyboard action; after the initial error, I was sitting there
trying to figure out where to look and the error would just pop up
again and again even though I wasn''t touching the screen (and no
one else was on the system at that moment).
Could this have to do with versions of Access? I develop in A97
and convert for delivery. I have A97 and AXP here at my office;
the client has A2000 (SP-3). They don''t have internet access at
all (don''t ask...) so they can''t download patches, etc; they''re
dependent on an IT staff that sometimes responds in a couple of
days but isn''t consistent.
Could it have to do with anti-virus software? (I''m grasping at
straws here, but the fact that it seems to occur independent of
keyboard action gets me wondering). They have McAfee VirusScan
Enterprise 8.0.0 running.
FYI, there are 3-5 users logged on at most times, and they (of
course) share a back end but each have a copy of the front end on
their c: drive.
Any recommendations, things to look for, etc.?
Jan
这篇关于错误3197但没有备注字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
