Access Has Encountered A Problem

C

Connie

Does anyone know why the error msg "MS Access has encountered a problem &
needs to close" occurs if a user presses Enter (instead of using the mouse)
on a command button which has code in the OnClick event? However, this
error msg does not appear until you click another command button. I put a
break in the code & stepped thru it & everything works correctly. I also
put a break in the 2nd command button but that code doesn't even executes ..
the msg comes up before triggering the 2nd command buttons OnClick event.
If the user clicks this 1st command button the error never occurs.
 
G

Guest

It sounds like your file may have become corrupted. Try a compact & repair.
It's located under Tools -> Database Utilities.
 
C

Connie

Thanks Mike for your suggestion, but I have done that on a daily bases ...
every time she got that error. A few times I have created a brand new BE
database & imported all the tables. BTW, I use a FE (mde file) & BE (mdb
file) & it's secured so there's also a mdw file. Also, each time this
happens I have copied a clean FE to each profile. What was hard to
troubleshoot was that she could work for a few hrs with no problem. After
about a month of this happening, I just happened to stumbled across what was
causing the error. I can reproduce this error each & every time if I press
ENTER, but if I CLICK the command button - no error msg.

Add'l Info:
This database has been up & running for over 6 months with 2 users & never
had this problem. I found out they're mouse users. Then beginning of May a
3rd user started using it & that's when this error msg started ... but only
for this 3rd user. I found out she tends to use keyboard more. All users
are accessing this db via terminal services. The 2 users are using a cable
connection, but the 3rd user is DSL. We were thinking maybe it was her
connection (plus she had a lot of spyware, which supposedly has been cleaned
up). But now that I can reproduce the error on my own PC I realize it's not
necessarily her connection. Also, I noticed in the help it states that if a
user presses the Enter key for a command button the OnClick will trigger.
So I don't know why this is happening.

I have turned the Tab Stop property to No so users must click, I just
uploaded these changes to the server, so hopefully this will resolve it, but
I'm just curious as to why this happened.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top