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. 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.
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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
by: Alex Vinokur |
last post by:
GNU g++ 3.3.3, Cygwin
// Stuff
static char* mbuffer = NULL;
// Stuff
void doit()
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
| |