新访问2K Bug？ [英] New Access 2K Bug?

问题描述

我最近在Access 2K工作（只有我的第二个

项目是100％A2K），我遇到了一些奇怪的事情。 >
似乎与运行代码有关的问题。


最近的一个问题是我正在处理的新表格，我

已经在表单上放置了一个导航组合框，我即将要用
写一个BeforeUpdate事件，该事件将使用Trevor Best的tCount（）

（替换为builtin dCount（））看看是否有任何

记录导航到或不导致取消更新，如果没有
那么。


到目前为止一切都那么好。


所以，我输入if TCount（从缺乏智能感知中看出我没有'b $ b避风港''然后将tCount（）导入到这个应用程序中。


所以，我从我的参考副本中复制代码然后将其粘贴到

我的模块中用于其他人们的代码。我点击编译，并得到一个错误

，因为我从一个非相关应用程序导入了一个表单，用作这个新应用程序中某些内容的

模型。所以，我重置代码和

然后删除模型表单。我收到一条错误消息，指出

无法暂停代码执行或者其他一些。但表格被删除了，所以我很高兴。然后我回到我打字的形式

tCount（并尝试继续其代码，但我不能 -

all努力查看其代码失败（包括使用项目

资源管理器，其中没有列出表单模块）。所以，我将

HasModule更改为NO，保存并重新打开表格，我可以再次工作。


现在，我认为这个问题可能是因为删除了一个表格导致了b / b
导致编译中断过程中我仍然有一个* b $ b *另一个*未清除的编译中断等待，但为什么它已损坏

一个不相关的形式，我不知道。


我遇到的另一个问题是，在一段时间之后

以及在我看不到任何模式的情况下，键盘只是

停止在Access 2K中工作。鼠标仍在A2K中工作，我不能看到任何代码正在执行，键盘

继续工作其他应用程序。我只能通过关闭A2K并重新启动来再次工作

。


Access的版本是9.0.3821 SR-1，这就是我用了很长时间在整个地方使用的
，并且在这台PC上花了很长时间（而且它是Jet SP6） ，以及）。虽然我在6月底重新安装了Win2K

，但这个问题仅在上个月出现了

左右。


现在，我知道我的键盘有点夸张（任何人都知道

你可以得到一个没有任何额外键的标准键盘

是耐用的不花钱吗？），但我已经有了这个键盘

大约18个月，所以我不能真的责怪它。

在安装了Blaster蠕虫病毒后，我安装了RPC补丁MS

后，问题就出现了。自从8月份从加利福尼亚回来以来，这是我系统中唯一的主要改变。


有何评论？

我发现它真的令人困惑的是VBE告诉我代码的方式

当我已经重置它时仍在执行。我真的不知道
了解发生了什么，并且使用A2K我觉得我无法控制使用A97来控制访问几乎和我一样。


-

David W. Fenton http://www.bway.net/~dfenton

dfenton at bway dot net http://www.bway.net/~dfassoc

I''m working in Access 2K quite a bit lately (with only my second
project that is 100% A2K), and I''ve run into a number of odd
problems that seem to be associated with running code.

The most recent problem was a new form that I was working on and I
had placed a navigation combo box on the form, and I was about to
write a BeforeUpdate event that would use Trevor Best''s tCount()
(replacement for the builtin dCount()) to see if there were any
records to navigate to or not and cancel the update if there
weren''t.

So far so good.

So, I type If tCount( and see from the lack of Intellisense that I
haven''t yet imported tCount() into this app.

So, I copy the code from my reference copy and go to paste it into
my module for other people''s code. I hit compile, and get an error
because I had imported a form from a non-related app to use as a
model for some of the things in this new app. So, I reset code and
then delete the model form. I get an error message that says
"cannot halt code execution" or some such. But the form was
deleted, so I was happy. I then go back to the form where I''d typed
tCount( and attempt to get to its code to continue, but I can''t --
all efforts to view its code fail (including using the Project
Explorer, where there is no form module listed). So, I change the
HasModule to NO, save and reopen the form and I can work again.

Now, I think the issue may have been caused by deleting a form that
had caused a break in the compile process while I still had
*another* uncleared compilation break pending, but why it corrupted
an unrelated form, I don''t know.

The other problem I''m having is that after certain periods of time
and in situations that I can''t see any pattern, the keyboard just
stops working in Access 2K. The mouse still works in A2K and I
can''t see that there''s any code executing, and the keyboard
continues to work in other applications. I can only get it to work
again by shutting down A2K and restarting.

The version of Access is 9.0.3821 SR-1, which is what I''ve been
using all over the place for a long time, and on this PC for quite
some time (and it''s Jet SP6, as well). Though I re-installed Win2K
at the end of June, this problem has only emerged in the last month
or so.

Now, I do know that my keyboard is a bit flakey (anyone know where
you can get a standard keyboard without any extra keys on it that
is durable and doesn''t cost a fortune?), but I''ve had this keyboard
for about 18 months and so I can''t really blame it on this.

Perhaps the problem emerged after I installed the RPC patches MS
put out after the Blaster worm emerged. That''s the only major
change to my system since I got back from California in August.

Any comments?

I just find it really confusing the way the VBE tells me code is
still executing when I''ve already reset it. I really don''t
understand what''s going on and with A2K I feel like I can not
control Access nearly as well as I can with A97.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

推荐答案

David ，

不知道这个''bug'是否是新的，但也许最近的帖子''Access 2000 corupting pattern''帮助

你的第一个问题？

我从另一个（A2000！）数据库导入代码时有类似的经验。

一次*没有*在表单中工作。似乎根本就没有代码...

即使是''关闭按钮''也没有'''''''。

紧凑型解决了但是我对A2000非常怀疑。


-

Arno R

" David W. Fenton" < DX ******** @ bway.net.invalid> schreef in bericht

news：94 *************************** @ 24.168.128.78 ..。

David,
Don''t know if this ''bug'' is new but maybe the recent thread ''Access 2000 corupting pattern'' helps
with your first problem?
I just had a similar experience while importing code from another (A2000!) db.
At once *nothing* worked in the form. Seemed like there was no code at all ...
Even the ''close-button'' didn'' ''work'' anymore.
A compact solved the case but I am getting very suspicious about A2000.

--
Arno R
"David W. Fenton" <dX********@bway.net.invalid> schreef in bericht
news:94***************************@24.168.128.78.. .

我最近在Access 2K工作了（只有我的第二个项目是100％A2K），我遇到了一些奇怪的
似乎与运行代码有关的问题。

最近的问题是我正在处理的新表单，我已经在表单上放置了一个导航组合框，我是即将
编写一个BeforeUpdate事件，该事件将使用Trevor Best的tCount（）
（替换内置dCount（））以查看是否有任何
记录导航到或不并取消更新，如果没有

那么好。

所以，我输入if TCount（并从缺乏Intellisense看到我还没有将tCount（）导入到这个应用程序中。

所以，我从我的参考副本中复制代码并将其粘贴到我的模块中其他人的代码。我打了com堆积，并得到一个错误
因为我从一个非相关的应用程序导入了一个表单，用作这个新应用程序中某些东西的模型。所以，我重置代码然后删除模型表单。我收到一条错误消息，指出
无法暂停代码执行或者其他一些。但表格已被删除，所以我很高兴。然后我回到我打字的形式
tCount（并尝试继续其代码，但我不能 -
所有查看其代码失败的努力（包括使用Project
Explorer，其中没有列出表单模块。。所以，我将
HasModule更改为NO，保存并重新打开表单，我可以再次工作。

现在，我认为这个问题可能是由于删除了一个在编译过程中导致中断的表单，而我仍然有另一个*未清除的编译中断，但为什么它已损坏一种不相关的形式，我不知道。

我遇到的另一个问题是，经过一段时间后，我无法看到任何问题。模式，键盘只是停止在Access 2K工作。鼠标仍在A2K工作，我无法看到有任何代码执行，键盘
继续在其他应用程序中工作。我只能通过shutt再次开始工作关闭A2K并重新启动。

Access的版本是9.0.3821 SR-1，这是我长期以来一直在使用的地方，以及这款PC非常有用（而且它也是Jet SP6）。虽然我在6月底重新安装了Win2K，但这个问题只在上个月出现了。

现在，我知道我的键盘是一个有点兴奋（任何人都知道在哪里你可以得到一个没有任何额外按键的标准键盘，
是耐用的并且不花钱？），但我有这个键盘
在我安装了Blaster蠕虫病毒后推出的RPC补丁MS后，问题就出现了。自从8月份从加利福尼亚回来以来，这是我系统的唯一主要变化。

有什么意见吗？

我发现它真的让人感到困惑当我已经重置它时，VBE告诉我代码仍在执行。我真的不明白发生了什么事情和A2K我觉得我无法控制Access几乎和A97一样。

- -
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http：//www.bway。 net /~dfassoc

I''m working in Access 2K quite a bit lately (with only my second
project that is 100% A2K), and I''ve run into a number of odd
problems that seem to be associated with running code.

The most recent problem was a new form that I was working on and I
had placed a navigation combo box on the form, and I was about to
write a BeforeUpdate event that would use Trevor Best''s tCount()
(replacement for the builtin dCount()) to see if there were any
records to navigate to or not and cancel the update if there
weren''t.

So far so good.

So, I type If tCount( and see from the lack of Intellisense that I
haven''t yet imported tCount() into this app.

So, I copy the code from my reference copy and go to paste it into
my module for other people''s code. I hit compile, and get an error
because I had imported a form from a non-related app to use as a
model for some of the things in this new app. So, I reset code and
then delete the model form. I get an error message that says
"cannot halt code execution" or some such. But the form was
deleted, so I was happy. I then go back to the form where I''d typed
tCount( and attempt to get to its code to continue, but I can''t --
all efforts to view its code fail (including using the Project
Explorer, where there is no form module listed). So, I change the
HasModule to NO, save and reopen the form and I can work again.

Now, I think the issue may have been caused by deleting a form that
had caused a break in the compile process while I still had
*another* uncleared compilation break pending, but why it corrupted
an unrelated form, I don''t know.

The other problem I''m having is that after certain periods of time
and in situations that I can''t see any pattern, the keyboard just
stops working in Access 2K. The mouse still works in A2K and I
can''t see that there''s any code executing, and the keyboard
continues to work in other applications. I can only get it to work
again by shutting down A2K and restarting.

The version of Access is 9.0.3821 SR-1, which is what I''ve been
using all over the place for a long time, and on this PC for quite
some time (and it''s Jet SP6, as well). Though I re-installed Win2K
at the end of June, this problem has only emerged in the last month
or so.

Now, I do know that my keyboard is a bit flakey (anyone know where
you can get a standard keyboard without any extra keys on it that
is durable and doesn''t cost a fortune?), but I''ve had this keyboard
for about 18 months and so I can''t really blame it on this.

Perhaps the problem emerged after I installed the RPC patches MS
put out after the Blaster worm emerged. That''s the only major
change to my system since I got back from California in August.

Any comments?

I just find it really confusing the way the VBE tells me code is
still executing when I''ve already reset it. I really don''t
understand what''s going on and with A2K I feel like I can not
control Access nearly as well as I can with A97.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

2003年9月24日星期三18:53:55 GMT， dX ******** @ bway.net.inva 盖子（David W.

Fenton）写道：


....

On Wed, 24 Sep 2003 18:53:55 GMT, dX********@bway.net.invalid (David W.
Fenton) wrote:

....

有什么意见吗？

我发现它真的让人混淆了VBE的说法当我已经重置它时，代码仍在执行。我真的不明白发生了什么，并且使用A2K我觉得我无法控制Access几乎和A97一样。

Any comments?

I just find it really confusing the way the VBE tells me code is
still executing when I''ve already reset it. I really don''t
understand what''s going on and with A2K I feel like I can not
control Access nearly as well as I can with A97.

我唯一的评论是，这类似于Access的无数问题

2000阻止我使用它。 IMO，Access 2002确实修复了Access 2000新增的问题，以使其值得使用。与A97相比，A2K2仍有更多的腐败问题，但在我的

体验中，A2K似乎比A2K有了很大提升。我也有更好的结果使用/ DECOMPILE修复问题

在A2K2中比以前在A97中做的那样，而A2K给了我一些

腐败似乎采取国会行动来解决问题。


我知道其余部分略微偏离了你的消息主题，但是现在

我是滚动< g> ;.


如果它不适用于接口和自定义事件等新功能，那么
可以很好地解决许多难以解决的编程问题，我仍然会坚持使用A97（我知道你与之相关的一种情绪），但新功能

足以让我进入A2K2阵营（我可以还没谈到A2K3。

接口解决了使用类进行抽象的问题，而没有
失去类型安全性，自定义事件解决了如何获得双向的问题
对象之间的通信，没有循环引用的危险和

内存泄漏。这是我书中的两个非常大的好处。


无论如何，这里有一个例子，我现在可以回忆一下工作中的事情

A97 ，在A2K中断开，并再次在A2K2中修复。 A2K中的表单'RecordsetClone

属性实际上是其Recordset属性的确切别名，而

与表单本身共享当前记录指针等。这打破了许多旧代码，包括我从MS知识库获取的例程
，以便在以绑定形式保存记录时捕获ODBC错误信息。在

A2K2中，表单'的RecordsetClone属性可以再次运行。


我有一个必须在A2K中运行的应用程序也必须捕获ODBC错误

信息并解释它以向

用户提供友好，信息丰富的消息。我不得不在我的工作中处理3个级别的错误，以使它工作。不，仅仅使用.Recordset.Clone是不够的，尽管这是几个人的第一步。

My only comment is that this is similar to a myriad of issues with Access
2000 that prevent me from using it. IMO, Access 2002 does fix just enough
of the problems new to Access 2000 to make it worth using. A2K2 still has
more corruption issues than A97, but seems much improved over A2K in my
experience. I''ve also had better results using /DECOMPILE to fix problems
in A2K2 than I ever did even in A97 before, while A2K has given me some
corruptions that seemed to take an act of congress to fix.

I know the rest of this is slightly off the topic of your message, but now
I''m on a roll <g>.

If it weren''t for new features like interfaces and custom events which
neatly solve many intractible programming problems, I would still be
sticking with A97 (a sentiment I know you relate to), but the new features
are just enough to drive me into the A2K2 camp (I can''t speak to A2K3 yet).
Interfaces solve the problem of using classes for abstraction without
losing type safety, and custom events solve how to get bidirectional
communication between objects without the danger of circular references and
memory leaks. That''s 2 very big benefits in my book.

Anyway, here''s an example I can recall right now of something working in
A97, broken in A2K, and fixed again in A2K2. A form''s RecordsetClone
property in A2K is actually an exact alias to its Recordset property and
shares a current record pointer, etc with the form itself. This breaks a
lot of old code including a routine that I got from the MS Knowledge Base
to capture ODBC error information when saving a record in a bound form. In
A2K2, the form''s RecordsetClone property works as it should again.

I have one app that had to run in A2K that also had to capture ODBC error
information and interpret it to give friendly, informative messages to the
user. I had to work around bugs in my work-arounds 3 levels deep to make
it work. No, it wasn''t enough just to use .Recordset.Clone, though that''s
the first step of several.

" David W. Fenton" < DX ******** @ bway.net.invalid>在消息中写道

news：94 *************************** @ 24.168.128.78 ..。

"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.78.. .

我发现它确实令人困惑VBE告诉我代码在我已经重置时仍在执行的方式。我真的不明白发生了什么，并且使用A2K我觉得我无法控制Access几乎和A97一样。

I just find it really confusing the way the VBE tells me code is
still executing when I''ve already reset it. I really don''t
understand what''s going on and with A2K I feel like I can not
control Access nearly as well as I can with A97.

那太好了，你自负了一块狗屎。这就是你得到的结果

听你的朋友Larry Linson。这就是2000年以前没有升级到Access的价值。这就是你认为你知道这一切的结果。

现在你完全迷失了，你仍然落后两个版本。那太好了！

That''s great, you conceited piece of shit. That''s what you get for
listening to your pal Larry Linson. That''s what you get for not upgrading
to Access 2000 years ago. That''s what you get for thinking you know it all.
Now you''re totally lost and you''re still two versions behind. That''s great!

这篇关于新访问2K Bug？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！