473,561 Members | 3,739 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access XP periodically crashing on requery - timing issue

I will try to be as descriptive as possible, but this error has me
stumped and I am not sure what relevant info to include....

I am running Access XP on a Windows XP machine. I initially began
developing an app in Access 2000 but converted it several months ago
to XP. So the app is now Access XP format also.

My app is crashing on a regular basis, with the totally non-descript
Microsoft error (Microsoft Access has encountered a problem and needs
to close. Do you want to send an error report to Microsoft?). Every
time, I send the error report to MS in the vain hope that this might
accomplish something. One time I actually received a response from
them, telling me that they were aware of a bug in Access XP that might
be causing my error, and that the bug would be fixed in Office XP
Service Pack 3 (which still has not been released).

Anyway, I'm not entirely convinced that it's a MS error because it
does not happen with regularity on the same event(s). The error
nearly always occurs on one particular form, when I click a button
that performs a series of queries based upon some "If Then"
conditions. After performing the queries, the main form (on which the
button is located) also performs a requery of two subforms (which are
continuous forms). All of this works fine (the queries, the If
conditions, and the two Requery events), so I do not believe I have a
code issue. However, about one time in every 10 (or 20, or so), I
click the button, the queries will run, and then (I think as it is
attempting the requery), I get the error and Access shuts down. What
I have noticed is that if I temporarily move the back-end off our
server and onto a local PC (where the front-end is housed), the error
occurs much less frequently (maybe once in every 50 tries instead of
once in every 10), which makes me think it may have something to do
with the timing of performing the queries and then attempting the
"requery" before the queries are finished. Otherwise, though, the
FE-BE setup seems to work fine (no real speed issues or anything).
Also, I am the only one using the app right now, so it's not an issue
of multiple users trying to access it at the same time or anything
like that.

Anyhow, I know there may be no one that can help based upon this
amount of information, but I am certainly open to any suggestions.

Based upon some others' helpful suggestions, I have tried the
following steps without success (i.e., I still get the same crash
every 10-20 attempts or so):

1. Creating a new .mdb and importing all of the objects
2. Inserting DoEvents before the Requery (as well as after each
individual query)
3. Changing all query calls from Docmd.OpenQuery to CurrentDb.Execu te
4. Inserting DBEngine.Idle dbRefreshCache before the Requery
5. Un-binding the forms, running the queries, then re-binding the
forms before the Requery

None of these actions seems to have any effect that I can tell. It
would be easier to debug if it crashed every time, but it doesn't.

Thanks in advance for any help.
Nov 12 '05 #1
3 2376
On 14 Jan 2004 14:54:01 -0800, pb******@yahoo. com (pbbriggs) wrote:

Does the recordsource of your form (or subforms) include a join to a table used to lookup related data for display only on your form?
I have had 3 "shutdown" problems with A2K2 which were all caused by the use of a join to a lookup table. All were fixed by removing the lookup table
and replacing it with a direct DLookup / TLookup to the table from the display control on the form.

Further info in -
http://www.google.com/groups?hl=en&l...4ax.com&rnum=3

I will try to be as descriptive as possible, but this error has me
stumped and I am not sure what relevant info to include....

I am running Access XP on a Windows XP machine. I initially began
developing an app in Access 2000 but converted it several months ago
to XP. So the app is now Access XP format also.

My app is crashing on a regular basis, with the totally non-descript
Microsoft error (Microsoft Access has encountered a problem and needs
to close. Do you want to send an error report to Microsoft?). Every
time, I send the error report to MS in the vain hope that this might
accomplish something. One time I actually received a response from
them, telling me that they were aware of a bug in Access XP that might
be causing my error, and that the bug would be fixed in Office XP
Service Pack 3 (which still has not been released).

Anyway, I'm not entirely convinced that it's a MS error because it
does not happen with regularity on the same event(s). The error
nearly always occurs on one particular form, when I click a button
that performs a series of queries based upon some "If Then"
conditions. After performing the queries, the main form (on which the
button is located) also performs a requery of two subforms (which are
continuous forms). All of this works fine (the queries, the If
conditions, and the two Requery events), so I do not believe I have a
code issue. However, about one time in every 10 (or 20, or so), I
click the button, the queries will run, and then (I think as it is
attempting the requery), I get the error and Access shuts down. What
I have noticed is that if I temporarily move the back-end off our
server and onto a local PC (where the front-end is housed), the error
occurs much less frequently (maybe once in every 50 tries instead of
once in every 10), which makes me think it may have something to do
with the timing of performing the queries and then attempting the
"requery" before the queries are finished. Otherwise, though, the
FE-BE setup seems to work fine (no real speed issues or anything).
Also, I am the only one using the app right now, so it's not an issue
of multiple users trying to access it at the same time or anything
like that.

Anyhow, I know there may be no one that can help based upon this
amount of information, but I am certainly open to any suggestions.

Based upon some others' helpful suggestions, I have tried the
following steps without success (i.e., I still get the same crash
every 10-20 attempts or so):

1. Creating a new .mdb and importing all of the objects
2. Inserting DoEvents before the Requery (as well as after each
individual query)
3. Changing all query calls from Docmd.OpenQuery to CurrentDb.Execu te
4. Inserting DBEngine.Idle dbRefreshCache before the Requery
5. Un-binding the forms, running the queries, then re-binding the
forms before the Requery

None of these actions seems to have any effect that I can tell. It
would be easier to debug if it crashed every time, but it doesn't.

Thanks in advance for any help.


Wayne Gillespie
Gosford NSW Australia
Nov 12 '05 #2
Wayne,
Thank you for the reply and the link to the other thread. My two
subforms do indeed have recordsources which are queries (and both
queries contain joins). Once I am able to get back to work on my app
(tomorrow), I will see if I can do the same think using Dlookup and
getting rid of the joins. Based upon your detailed post in the other
thread, it sounds like I may be experiencing the same thing that
happened to you. To be honest, I did suspect it was something
peculiar to A2K2 because I started developing the app in A2K and never
had this problem. However, I had made so many other changes since
that time, there was no real way for me to tell for certain if it was
a version-specific problem.
I will post back once I've had a chance to implement your suggestion.
Thank you.
Patricia

Wayne Gillespie <be*****@NObest fitsoftwareSPAM .com.au> wrote in message news:<9s******* *************** **********@4ax. com>...
On 14 Jan 2004 14:54:01 -0800, pb******@yahoo. com (pbbriggs) wrote:

Does the recordsource of your form (or subforms) include a join to a table used to lookup related data for display only on your form?
I have had 3 "shutdown" problems with A2K2 which were all caused by the use of a join to a lookup table. All were fixed by removing the lookup table
and replacing it with a direct DLookup / TLookup to the table from the display control on the form.

Further info in -
http://www.google.com/groups?hl=en&l...4ax.com&rnum=3

Nov 12 '05 #3
Well, no luck. I finally got to implement Wayne's suggestion. My
forms' recordsources now are without joins. Unfortunately, I'm still
encountering the problem. To top it all off, now I am occasionally
getting a Microsoft "Runtime Error! This application has requested
the Runtime to terminate in an unusual way" error.

If anyone has any other ideas, I'd greatly appreciate it.
Thanks
Patricia

pb******@yahoo. com (pbbriggs) wrote in message news:<98******* *************** ****@posting.go ogle.com>...
Wayne,
Thank you for the reply and the link to the other thread. My two
subforms do indeed have recordsources which are queries (and both
queries contain joins). Once I am able to get back to work on my app
(tomorrow), I will see if I can do the same think using Dlookup and
getting rid of the joins. Based upon your detailed post in the other
thread, it sounds like I may be experiencing the same thing that
happened to you. To be honest, I did suspect it was something
peculiar to A2K2 because I started developing the app in A2K and never
had this problem. However, I had made so many other changes since
that time, there was no real way for me to tell for certain if it was
a version-specific problem.
I will post back once I've had a chance to implement your suggestion.
Thank you.
Patricia

Wayne Gillespie <be*****@NObest fitsoftwareSPAM .com.au> wrote in message news:<9s******* *************** **********@4ax. com>...
On 14 Jan 2004 14:54:01 -0800, pb******@yahoo. com (pbbriggs) wrote:

Does the recordsource of your form (or subforms) include a join to a table used to lookup related data for display only on your form?
I have had 3 "shutdown" problems with A2K2 which were all caused by the use of a join to a lookup table. All were fixed by removing the lookup table
and replacing it with a direct DLookup / TLookup to the table from the display control on the form.

Further info in -
http://www.google.com/groups?hl=en&l...4ax.com&rnum=3

Nov 12 '05 #4

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

Similar topics

14
5249
by: JK Peck | last post by:
I have a fairly large Access application that ran correctly in Access 2000. After upgrading to Access 2003 (and recompiling and updating references), it reliably crashes at a certain point. If I step through the VBA code, the crash does not occur. What is different about stepping through code instead of just running it? Any idea how to...
49
14294
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The application is relatively big: around 200 tables, 200 forms and sub-forms, 150 queries and 150 repports, 5GB of data (SQL Server 2000), 40 users. ...
6
2452
by: AAJ | last post by:
Hi all I have a listbox on a form. If I set its rowsource directly, and the query in the rowsourse returns no data, then the displayed listbox is empty (exactly as you would expect) However.... If I programatically set the rowsource, and the query returns no records then access completely crashes and switches its self off,
2
3501
by: Wayne | last post by:
I've found a few posts on this subject but no reason for the behaviour. Is there any logical reason that Docmd.Requery "MyControl" won't work under Access 2K but Me.Requery.MyControl will? Is there a list anywhere of any other little "gotchas" like this one when running under Access 2K?
6
9942
by: Mark | last post by:
Hello. I have a listbox whose rowsource is set to a saved query (call it "qry_customer_list.") When I add customers to my database, I call the listbox Requery method so that the listbox will display the customers that I added. Unfortunately, the listbox display does not change. If I close the form and reload it, then the listbox will show...
0
1450
by: JACompute | last post by:
I have an invoicing system that uses a VB6 program to post new invoice entries to a centralized Vendor management system (also in VB6), via a Web server and some ASP code. The system has been in production for some time now, but one pesky little problem keeps surfacing periodically. System Description: 1. For each new line on an invoice, a...
11
8397
bhcob1
by: bhcob1 | last post by:
Hi, Whenever I delete a record my command button, the record deletes, a list displaying all records is updated and then a message box appears: Microsoft Access can't find the field 'I' referred to in your expression It only has the option of clicking 'OK', when I do this everything is fine again. I would like to know what is going on and...
16
3538
by: google | last post by:
In a continuous form the following code is under a button in the form header. In Access 2003 and earlier, this goes to a new record, then adds relevant data to that new record. DoCmd.GoToRecord , , A_NEWREC If <some codeThen = "CA002" Else
5
1903
by: Lyn | last post by:
From time to time I strike a problem where Access will suddenly shut down while running some code (Dr Watson message), wiping out any forensics (diagnostic traces such as debug.prints, etc). This is frustrating enough, but if I step through the same code one instruction at a time, it always functions perfectly. I have usually resolved the...
0
7647
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7570
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8088
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7618
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7930
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5187
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3617
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2068
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1181
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.