Solved

Dr. Watson error in Access???

Posted on 2001-08-28
12
373 Views
Last Modified: 2008-03-10
I am running NT 4.0 and Access 97 on a Gateway machine.  On certain Access queries, I get a Dr. Watson for Windows NT intercept that closes Access.  The Dr. Watson message box reads:

An application error has occurred and an application log is being generated.

msaccess.exe

Exception: access violation (0xc0000005), Address:0x0401f9f3

If I was lead programmer at Microsoft, this and the information in the log file might tell me something.  But, alas, this is not the case.  Where can I find what this is supposedly telling me?  I am seriously considering disabling Dr. Watson and let Access tell me what is wrong.  
0
Comment
Question by:jstiefel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 8

Expert Comment

by:dovholuk
ID: 6435019
well let me tell ya. i get these so often my head spins. i think that it's a function of how big you let your db get and what you try to do when it gets "bloated".  i'm sure that you've seen "access bloat" before. a 10 mb .mdb file that compacts to 1 mb is a prime example.  what i do to alleviate these errors is to decompile the database and recompile it. try this by using the /decompile switch from the start->run box or a command prompt...

usage:
[drive][path]msaccess.exe [FilePath][FileName] /decompile

example
c:\progra~1\office\msaccess.exe c:\MyApp\MyApp.mdb /decompile

once decompiled, open any module and choose debug->compile and save ALL modules (a97) or debug->compile db (a2k)

i have a LOT of code in one particular db, and decompiling and recompiling fixes 99.9% of my errors while under development. post development, i've never seen these errors. (plenty of other runtime errors though...)

hope it helps. i'm not sure that it will, but it's a good start.

dovholuk
0
 
LVL 14

Accepted Solution

by:
mgrattan earned 100 total points
ID: 6435169
dovholuk's suggestions are very good advice.  I would also check to make sure you have the latest service release for Access 97 (not sure if it's SR-1, SR2, or later) just to make sure all of the supporting DLLs are up to date.  

Also, if you are calling any custom functions from within your queries, you could open the function and put a break point in the code and then step through it as the query is running to see if something in the code is causing the problem.

Furthermore, problems of this nature can sometimes by resolved by creating a new, empty, database and importing all of the objects from the "broken" database into the new one and then recompiling the code from the VBA module design view (select Debug, Compile and Save all Modules).

0
 

Author Comment

by:jstiefel
ID: 6438975
Dovholuk
Being the staunch believer in Murphy's law that I am, I fell in the 0.1% that decompiling doesn't help.  I compacted, decompiled, compiled and recompacted.  Dr. Watson still threw me out of Access.

Mgrattan
I probably have the latest SRs but I will check.  

As for importing the objects into an empty new database, the database I am in was originally developed for a similar but not as far reaching application.  I am using this as a developmental platform before I plug it into the working application.  Something may have gone haywire in the developemental database.  I'll try that also.  

The query(ies) that crash Access are group-by, aggregrate queries (group-by, avg, max).  They work by themselves but crash when linked to anything else in the final query behind the form.

I was thinking about disabling Dr. Watson.  Before I do this I am going to off load this database and two other linked databases and run them at home on Win 98 but no Dr. Watson and see if Access can tell me more.


0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 8

Expert Comment

by:dovholuk
ID: 6440807
jstiefel,

how interesting... i just created a query which will fail 100% of the time, causing an error... i've posted the snapshot to
http://www.geocities.com/dovholuk/20175378.bmp

the query i am using contains two separate sub-queries, are you using sub-queries as well???

very odd. i hate it when access can "handle it".

dovholuk
0
 
LVL 57
ID: 6440849
Just an FYI: Dr. Watson can actually cause errors.  Try turning him off and you may find you don't have a problem<g>.

Jim.
0
 

Expert Comment

by:Mevis
ID: 6460183
Dr. Watson is mostly occuring when you made a complicated or wrong query. If the query is right, open a new database and import the old db. It will be stable for some time, untill your making your next ugly query.
0
 

Author Comment

by:jstiefel
ID: 6462737
Dovholuk
The link that you inserted "is not available"
------------
The query that creates the problem is complicated.

I imported the objects into a new database and the problem was still there.

I ran it on my home computer with Win 95 and no Dr. Watson.  I got the following error message:

MSACCESS caused a general protection fault
in module USER.EXE at 0007:000072c6.
Registers:
EAX=0bff0046 CS=17a7 EIP=000072c6 EFLGS=00000246
EBX=00010000 SS=1bc7 ESP=00008d58 EBP=00628d74
ECX=00020000 DS=16df ESI=000254d8 FS=2c17
EDX=00001fff ES=0aef EDI=00024bcc GS=0000
Bytes at CS:EIP:
17 33 c0 1f 5e 66 5f c9 ca 12 00 90 90 90 c8 16
Stack dump:
00024614 00004bcc 00030000 01000000 f0600af7 01240000 00000af7 24b98266 4e101757 4e100002 000c0002 00000000 0140272f 297d8290 82901757 021426f8
 
After this error occurs, other Microsoft programs I run develops the same error (Word, IE, WE ).  I even got the Dr. Watson error at work using an FMS program called Total Access Analyzer.  I haven't contacted them yet if they might have an answer.
0
 
LVL 8

Expert Comment

by:dovholuk
ID: 6462768
sorry. i had to clean house on the acct! doh.

anyway, it was the same error type of error you just posted. it happened EVERY time i tried to run the query. 100% confidence.

can you post the query here?

i would suggest you try to create multiple queries. i think that some stack somewhere is being overloaded and causing the gpf (which apparently is not removed from memory on the error).  if you broke the query apart it might actually work????

just throwing out an idea...

dovholuk

0
 

Author Comment

by:jstiefel
ID: 6466039
First, would the SQL for the query be what you need?

Second, instead of trying to come up with one super query, I used subforms linked to the general information on the main form.  This got me around the problem and taught me not to go for one super query behind a form or report.
0
 
LVL 8

Expert Comment

by:dovholuk
ID: 6466075
1) yes the sql query AND as much table structure you can provide would be very beneficial.

2) so have you developed a work-around or are you still looking for ideas?

dovholuk
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6989672
for jstiefel

It's time to clean up this TA, so I will leave a recommendation in Community Support that this question is:
 - Answered by: dovholuk (200pts) and mgrattan (100pts)
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Expert Comment

by:Netminder
ID: 7003449
Per recommendation, force-accepted by
Netminder
CS Moderator

dovholuk: points for you at http://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=20299555 and an old "points for" question for you at http://experts-exchange.com/questions/Q.20290223.html
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question