Access 2003崩溃 [英] Access 2003 Crash

问题描述

我有一个相当大的Access应用程序在Access中正确运行

2000.升级到Access 2003（并重新编译和更新

引用）之后，它可靠地崩溃了某一点。如果我通过VBA代码执行
，则不会发生崩溃。


通过代码而不是仅仅运行代码有什么不同

it？


任何想法如何找到原因？我知道它发生在哪里，但

因为它本身就是崩溃，找到一个解决方法只是试用

和错误。

I have a fairly large Access application that ran correctly in Access
2000. After upgrading to Access 2003 (and recompiling and updating
references), it reliably crashes at a certain point. If I step
through the VBA code, the crash does not occur.

What is different about stepping through code instead of just running
it?

Any idea how to find the cause? I know about where it happens, but
since it is Access itself crashing, finding a workaround is just trial
and error.

推荐答案

您是否使用Office Update确保您拥有所有更新到
Office 2003（它们将是补丁，而不是Service Pack，位于这一点）

和Jet 4.0（这取决于Office 2003的Service Pack 8）？


访问自身崩溃不是正常的行为。我可以向你保证，在按设计工作的类别中，这不是b $ b。由于_should_什么都没有用户可以做到这一点，我怀疑这将是一个免费的事件与支持团队的b
你可以打电话询问）。


除非他们有一个尚未经过全面测试和发布的补丁但是，b $ b适用，但是，我有理由相信其中一个他们将建议你首先卸载Office / Access，然后重新安装它，

然后运行Office更新。无论是否能解决问题，通常都需要做一些事情来消除安装错误。并且，

完全有可能触发崩溃的是一些

Access正在使用的外部函数，所以它可能不是
中的东西
访问权限或办公室。


当您单步执行代码和运行代码时，时序会有所不同。但是，从用户的b $ b用户的角度来看，我们无法做任何关于

时间问题的事情。在主机内部（在这种情况下是Access）。


但是，如果你可以缩小它发生的位置，如果它在代码中，并且

你在那个区域附近发布了一些代码，你最好猜测它发生在哪里，也许有人可以提出另一种方法来做_might_ not

触发同样的后果。不要指望，但这是可能的。


Larry Linson

Microsoft Access MVP

" JK Peck < PE ** @ spss.com>在消息中写道

news：bc ************************** @ posting.google.c om ...

Have you used the Office Update to assure that you have all the updates to
Office 2003 (they''d be patches, rather than Service Packs, at this point)
and to Jet 4.0 (it''s up to Service Pack 8, for Office 2003)?

"Access itself crashing" isn''t normal behavior. I can assure you that is not
in the category of "working as designed". Since there _should_ be nothing
the user can do to cause this, I''d suspect it would be a free incident with
the support team (you could call and ask).

Unless they have a patch that hasn''t yet been fully tested and released that
applies, however, I am reasonably sure that one of the things they will
suggest is that you first uninstall Office/Access, and then re-install it,
then run Office update. Whether that will fix the problem or not, it''s
something that usually has to be done to eliminate an install error. And,
it''s entirely possible that whatever is triggering the crash is some
external function that Access is using, so it might not be something in
Access or Office.

Timing is different when you step through code and when you run it. From a
user point of view, though, there''s not really anything we can do about
"timing problems" inside the host (Access, in this case).

But, if you can narrow down where it is happening, if that is in code, and
you post some code around that area, with your best guess at where it
happens, maybe someone could suggest another way to do it that _might_ not
trigger the same consequences. Don''t count on that, but it''s a possibility.

Larry Linson
Microsoft Access MVP
"JK Peck" <pe**@spss.com> wrote in message
news:bc**************************@posting.google.c om...

我有一个相当大的Access应用程序在Access
2000中正确运行。升级到Access 2003（并重新编译和更新
引用）后，它在某个点上可靠地崩溃。如果我通过VBA代码步骤，则不会发生崩溃。

通过代码而不是仅仅运行代码有什么不同？
知道如何找到原因吗？我知道它发生在哪里，但是因为它本身就是崩溃，找到一个解决方法只是试用
和错误。

I have a fairly large Access application that ran correctly in Access
2000. After upgrading to Access 2003 (and recompiling and updating
references), it reliably crashes at a certain point. If I step
through the VBA code, the crash does not occur.

What is different about stepping through code instead of just running
it?

Any idea how to find the cause? I know about where it happens, but
since it is Access itself crashing, finding a workaround is just trial
and error.

我确实检查了更新，我发现没有可用的。我的访问版本

是11.5614.5703，而Jet 4.0 SP8。


我怀疑是竞争状况或其他时间问题并且放置了一些

在可疑区域发出警报，使应用程序在代码中暂停几次

，但崩溃仍然发生。遗憾的是，一些随机排列的代码

给出了相同的结果。


我想知道单步执行是否绕过了代码中的任何优化

（如果有任何编译时）。但是我不能真的要求用户使用单步代码来完成他们的工作！


这发生在两个不同的最近Access上2003系统，一个在
赢得2K，一个在WinXP上。


***通过Developersdex发送 http://www.developersdex.com ***

不要只是参加USENET ...奖励它！

I did check for updates, and I found none available. My Access version
is 11.5614.5703, and Jet 4.0 SP8.

I suspected a race condition or other timing problem and placed some
alerts in the suspect areas to make the application pause several times
in the code, but the crash still occurs. Some random permuting of code
gave the same result, unfortunately.

I wondered whether single stepping bypassed any optimization in the code
(if there is any when compiling). But I can''t really ask users to
single step the code in order to get their job done!

This has occurred on two different recent Access 2003 systems, one on
Win 2K and one on WinXP.

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

pe**@spss.com （JK Peck）写道：

pe**@spss.com (JK Peck) wrote:

我有一个相当大的Access应用程序，可以在Access
2000中正确运行。升级到Access 2003（并重新编译和更新
引用）后，它会在某个时刻可靠地崩溃。如果我通过VBA代码步骤，则不会发生崩溃。

I have a fairly large Access application that ran correctly in Access
2000. After upgrading to Access 2003 (and recompiling and updating
references), it reliably crashes at a certain point. If I step
through the VBA code, the crash does not occur.

尝试在代码中插入一些DoEvents。


Tony

-

Tony Toews，Microsoft Access MVP

请仅在新闻组中回复，以便其他人可以

阅读整个消息主题。

Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm

这篇关于Access 2003崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！