By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

New Access 2K Bug?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
11 Replies


P: n/a
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.. .
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


Nov 12 '05 #2

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

....
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.


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.
Nov 12 '05 #3

P: n/a

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

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.


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!
Nov 13 '05 #4

P: n/a
"Anonymous Sender" <an*******@remailer.metacolo.com> wrote in message
news:59******************************@remailer.met acolo.com...
In article <RL********************@vnet-inc.com>
"XMVP" <ac***********@hotmail.com> wrote:
That's great, . . .

Are you surprized? . . .
From the headers of the referenced message:
Comments: This message did not originate from
the Sender address above. It was remailed auto-
matically by anonymizing remailer software.
Please report problems or inappropriate use to the
remailer administrator at <ab***@remailer.metacolo.com>.
X-No-Archive: Yes


Whether or not "Anonymous Sender" and "XMVP" are the same individual, both
are just trolling while hiding their identity behind anonymizing entities.
Nov 13 '05 #5

P: n/a

"Anonymous Sender" <an*******@remailer.metacolo.com> wrote in message
news:59******************************@remailer.met acolo.com...
In article <RL********************@vnet-inc.com>
"XMVP" <ac***********@hotmail.com> wrote:


"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:94***************************@24.168.128.78.. .
>
> 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.
>


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!

Are you surprized? Have you seen David's apartment in Manhattan? It's
made
up like a freaking 19th century French whorehouse.


And yes I've seen David's apartment. As a matter of fact, I decorated it
when we were living together.
Nov 13 '05 #6

P: n/a
"Larry Linson" <ga******@butt.com> wrote in message
news:1096679737.nFvTIOJ4GQuYRkg7jbbQZg@teranews...

The referenced message is an impersonation, used by the troll to reinsert
his misleading quotes.
Nov 13 '05 #7

P: n/a
By forging your name, might this be a criminal offense? Being an idiot is
not a criminal offense, otherwise this kid would be serving an indefinite
sentence in juvenile detention, but perhaps we could finally be done with
this kid if the moron has finally crossed the criminal line.
Darryl Kerkeslager

"Larry Linson" <bo*****@localhost.not> wrote in message
news:qYp7d.642$1g5.560@trnddc07...
"Larry Linson" <ga******@butt.com> wrote in message
news:1096679737.nFvTIOJ4GQuYRkg7jbbQZg@teranews...

The referenced message is an impersonation, used by the troll to reinsert
his misleading quotes.

Nov 13 '05 #8

P: n/a

"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:28********************@comcast.com...
By forging your name, might this be a criminal offense? Being an idiot is
not a criminal offense, otherwise this kid would be serving an indefinite
sentence in juvenile detention, but perhaps we could finally be done with
this kid if the moron has finally crossed the criminal line.
Darryl Kerkeslager

I just realized there might be more than one Darryl Kerkeslager in the
world! How dumb of me!
Nov 13 '05 #9

P: n/a

"Darryl Kerkeslager" <du********@noname.com> wrote in message
news:1096750196.s18QXhbUqY50FOHe1adOgw@teranews...

"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:28********************@comcast.com...
By forging your name, might this be a criminal offense? Being an idiot
is
not a criminal offense, otherwise this kid would be serving an indefinite
sentence in juvenile detention, but perhaps we could finally be done with
this kid if the moron has finally crossed the criminal line.
Darryl Kerkeslager

I just realized there might be more than one Darryl Kerkeslager in the
world! How dumb of me!

I doubt there's that many mean parents in the world who'd name their kids
Darryl AND Kerkeslager But I did grew up with a kid named Danny
Kerkeslager who was retarded. I also dated a girl in college named Darlene
Kerkeslager but she was a slut and gave everybody the clap. Once when I
lived in Philadelphia a guy named Dennis Kerkeslager threw two puppies under
the wheels of a garbage truck and got 30 days in jail. His brother Kirk
Kerkeslager got arrested too.

Nov 13 '05 #10

P: n/a
> I just realized there might be more than one Darryl Kerkeslager in the
world! How dumb of me!

Oh yeah, there's lot of us. School's out for the weekend, I see.


"Darryl Kerkeslager" <du********@noname.com> wrote in message
news:1096750196.s18QXhbUqY50FOHe1adOgw@teranews...
"Darryl Kerkeslager" <Ke*********@comcast.net> wrote in message
news:28********************@comcast.com...
By forging your name, might this be a criminal offense? Being an idiot is not a criminal offense, otherwise this kid would be serving an indefinite sentence in juvenile detention, but perhaps we could finally be done with this kid if the moron has finally crossed the criminal line.
Darryl Kerkeslager


Nov 13 '05 #11

P: n/a
"Larry Linson" <bo*****@localhost.not> wrote in
news:qYp7d.642$1g5.560@trnddc07:
"Larry Linson" <ga******@butt.com> wrote in message
news:1096679737.nFvTIOJ4GQuYRkg7jbbQZg@teranews...

The referenced message is an impersonation, used by the troll to
reinsert his misleading quotes.


I don't even live in Manhattan.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #12

This discussion thread is closed

Replies have been disabled for this discussion.