Solved

Dr. Watson ACCESS Violation Error

Posted on 2001-08-05
9
340 Views
Last Modified: 2008-02-01
While performing Compile and Save of a module I am now getting a Dr. Watson ACCESS Violation error.  This is happening if I try to compact the database or compile and save any of the procedures or code in any form.  

Bob Scriver
0
Comment
Question by:Bob Scriver
  • 4
  • 3
  • 2
9 Comments
 
LVL 12

Expert Comment

by:Paurths
ID: 6353547
hi scriverb,

what access version is this?
What windows version?

Also, can u post the exact message?

cheers
Ricky
0
 
LVL 3

Author Comment

by:Bob Scriver
ID: 6353584
Paurths:
Thanks for the comeback.  ACCESS 97, Windows NT 4.0 and the message is:

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

msaccess.exe  Exception: access violation (0xc0000005), Address: 0x6517daaa

Now after returning to a backup working database I have reentered the most recent code that was entered before the problem and have found a Mid$ function call that could start at position 0 in some instances but I thought that that would only cause an error during the execution of the code.  I was just trying to compile the modules when this occurred.  After fixing this code I have now been able to get everything working right with no errors.  But, I do want to understand the meaning of this problem.  What I did to create it so that I can avoid it in the future.

I can send you the problem code if you would like.  

Bob Scriver
0
 
LVL 12

Expert Comment

by:Paurths
ID: 6353886
ok Bob,

i can test it tomorrow at work then, where i have NT 4.0 also: ricky.thijs@pandora.be

cheers
Ricky
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 3

Author Comment

by:Bob Scriver
ID: 6354360
Paurths,  I have sent you an email with the code and a sample database.  

Bob Scriver
0
 
LVL 6

Expert Comment

by:devtha
ID: 6355860
Dr watson is very sparse and vague error. Usually in Access it is the result of the way methods are used.
For instance in the properties windows you access a property using down arrow key Vs Mouseclick. For such a case the MS explanation is use down arrow instead of mouse click. It is also very strange that it does not happen on all machines. My users for an app were getting this message but not me. Thus I was not able to troubleshoot it. Finaly I just decided (just a hunch) to convert all the make table to append queries and bingo, Dr watson was cured..
Good debugging skills are very helpful here...
0
 
LVL 6

Expert Comment

by:devtha
ID: 6357131
??????????
0
 
LVL 3

Author Comment

by:Bob Scriver
ID: 6357721
devetha,
Sorry about the delay in responding, meetings, etc.  I have solved my problem as I stated earlier.  Just dropping back to a backup copy of the database and reentering the code with a slight variation.  Everything is working as planned with no more problem.  Thank god for keeping backups of working copies of our databases.  

It is still puzzling but I believe that the form got corrupted during a compile and was not able to correct itself.  I have had that happen before and lost a lot of work while having to recereate a form.  But not this time.  I only work on working copies of my databases and swap them up every two hours during development.  That way I can keep most of my hair in my head rather than pulling it out in frustration.

Thanks again for the suggestions.

Bob Scriver
0
 
LVL 6

Accepted Solution

by:
devtha earned 100 total points
ID: 6406653
reverting back to a backup will not solve this you may get this again.
Try running this command form the start - run
msaccess /decompile
then select your database. Then do a compile and save all mods and then do a compact.
0
 
LVL 3

Author Comment

by:Bob Scriver
ID: 6406706
Thank you.  That is easy enough.  I will do this in the future if I get the same problem.

Bob Scriver
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

808 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