473,324 Members | 2,166 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Click causes crash

I am front ending a SQL Server database with MS-Access 2000. The UI has
many buttons that launch VB code. One of the buttons launches a lengthy
process that takes 20-30 seconds to complete. If the user starts
clicking their mouse off of the active window the Access Toolbar
displays Microsoft Access (Not Responding) and then moments later a
hard crash occurs and is announced by a system dialog box. When the
user clicks the OK button in the dialog box Access terminates and needs
to be restarted.

Things I've tried:

Popping up a form announcing "Processing". The form has both Pop Up and
Modal attributes set to Yes. (BTW - Even if the form displays "Don't
click the mouse while this is working" the users still do and crash the
program).

Turned the Pop Up and Modal attributes to No.

Better indexed my data.

Enabled the "Raise execution priority from Windows applications" option
in SQL Server.

Thanks in advance. Any help would be greatly appreciated.

Oct 24 '06 #1
3 2357
If the process is part of a loop, you could use the DoEvents function
to allow the operating system to process the mouse click events. If
this isn't possible, perhaps if you posted the process code here, a
solution could be found. If you'd like, you could even email to me and
I'll see if I can see anything that might help.
Typehigh wrote:
I am front ending a SQL Server database with MS-Access 2000. The UI has
many buttons that launch VB code. One of the buttons launches a lengthy
process that takes 20-30 seconds to complete. If the user starts
clicking their mouse off of the active window the Access Toolbar
displays Microsoft Access (Not Responding) and then moments later a
hard crash occurs and is announced by a system dialog box. When the
user clicks the OK button in the dialog box Access terminates and needs
to be restarted.

Things I've tried:

Popping up a form announcing "Processing". The form has both Pop Up and
Modal attributes set to Yes. (BTW - Even if the form displays "Don't
click the mouse while this is working" the users still do and crash the
program).

Turned the Pop Up and Modal attributes to No.

Better indexed my data.

Enabled the "Raise execution priority from Windows applications" option
in SQL Server.

Thanks in advance. Any help would be greatly appreciated.
Oct 24 '06 #2
Brian,

I tried it, but the program still crashes hard.
It's the Access version of the BSOD (Blue Screen Of Death)

Neil

Brian Puffer wrote:
If the process is part of a loop, you could use the DoEvents function
to allow the operating system to process the mouse click events. If
this isn't possible, perhaps if you posted the process code here, a
solution could be found. If you'd like, you could even email to me and
I'll see if I can see anything that might help.
Typehigh wrote:
I am front ending a SQL Server database with MS-Access 2000. The UI has
many buttons that launch VB code. One of the buttons launches a lengthy
process that takes 20-30 seconds to complete. If the user starts
clicking their mouse off of the active window the Access Toolbar
displays Microsoft Access (Not Responding) and then moments later a
hard crash occurs and is announced by a system dialog box. When the
user clicks the OK button in the dialog box Access terminates and needs
to be restarted.

Things I've tried:

Popping up a form announcing "Processing". The form has both Pop Up and
Modal attributes set to Yes. (BTW - Even if the form displays "Don't
click the mouse while this is working" the users still do and crash the
program).

Turned the Pop Up and Modal attributes to No.

Better indexed my data.

Enabled the "Raise execution priority from Windows applications" option
in SQL Server.

Thanks in advance. Any help would be greatly appreciated.
Oct 27 '06 #3
Brian,

Thanks for the tip, it got me thinking and trying new things.

I got the code to work using DoEvents and here is how I did it:

FOR intX = 1 TO SomeLargeNumber
code
code
code
code
IF intX MOD 200 = 0 THEN
DoEvents
END IF
NEXT

The reason I did it this way is because DoEvents will slow a loop down,
so I only evoke it every 200 loop cycles.

Thanks again,

Neil
Typehigh wrote:
Brian,

I tried it, but the program still crashes hard.
It's the Access version of the BSOD (Blue Screen Of Death)

Neil

Brian Puffer wrote:
If the process is part of a loop, you could use the DoEvents function
to allow the operating system to process the mouse click events. If
this isn't possible, perhaps if you posted the process code here, a
solution could be found. If you'd like, you could even email to me and
I'll see if I can see anything that might help.
Typehigh wrote:
I am front ending a SQL Server database with MS-Access 2000. The UI has
many buttons that launch VB code. One of the buttons launches a lengthy
process that takes 20-30 seconds to complete. If the user starts
clicking their mouse off of the active window the Access Toolbar
displays Microsoft Access (Not Responding) and then moments later a
hard crash occurs and is announced by a system dialog box. When the
user clicks the OK button in the dialog box Access terminates and needs
to be restarted.
>
Things I've tried:
>
Popping up a form announcing "Processing". The form has both Pop Up and
Modal attributes set to Yes. (BTW - Even if the form displays "Don't
click the mouse while this is working" the users still do and crash the
program).
>
Turned the Pop Up and Modal attributes to No.
>
Better indexed my data.
>
Enabled the "Raise execution priority from Windows applications" option
in SQL Server.
>
Thanks in advance. Any help would be greatly appreciated.
Nov 2 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Dom | last post by:
Hi, I am trying to get a dynamic table going. You click a button to add a row. In the newly created row a button to delete the row is placed (try the code example below). In Netscape, pressing...
10
by: Alex Vinokur | last post by:
GNU g++ 3.3.3, Cygwin // Stuff static char* mbuffer = NULL; // Stuff void doit()
3
by: Matias Silva | last post by:
Hi Everyone, I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute the query with a UNION...
1
by: John C | last post by:
Importing DBase files I get to the screen titled "Select Source Table and Views" And none appear in the list. (I can get the list displayed about once in ten tries) From that screen anything causes...
8
by: Adam Louis | last post by:
I would like help resolving this problem. I'm a novice who's been hired to query a hospital database and extract useful information, available to me only in a dynamically generated, downloadable...
1
by: Tim Marshall | last post by:
Given a bound continuous subform in an unbound main form, a button on the subform sets allowadditions = true and dataentry = true. This works no problem. But a second button on the subform...
2
by: Composer | last post by:
One form in my Access 2000 mdb causes a crash whenever I close it. The crash is of the type where I get a "Please tell Microsoft about this problem". Easy, you think! Well, here are the things...
2
by: Dino M. Buljubasic | last post by:
I have a list view with couple of items in it. When I left click on an item, a form opens displaying that item's properties. So that works fine. However, accidentally I found out that when I...
3
by: Nalaka | last post by:
Hi, Can you tell me what type a things in asp.net code can crash... "application pool". Any example would do.... I was under imresiion that code cannot crash the app pool. Any direction is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.