Solved

Faulting application msaccess.exe --HELP--

Posted on 2004-08-17
8
5,471 Views
Last Modified: 2008-01-09
I have an access database that we use to run reports.  This database was developed my one of our developers who is co working on this problem with me the network admin.

This database suddenly started having a problem where it would crash and give an error.  After the error the access application would just “close out” when we tried to use in on that PC.  By “close out” I mean access will disappear from the screen and task manager without any error or notice; gone in a blink.  Other PC’s would be fine until or if the get the initial crash. The only way I have been able to resolve this problem, once access was “closing out” is to re-install the entire OS and applications, nothing else seems fix the problem.

The error that initially happens seems to be one of two things, most of the time we get: event id 1000             Microsoft Office 10

Faulting application msaccess.exe, version 10.0.6501.0, faulting module ntdll.dll, version 5.0.2195.6899, fault address 0x0004caaf.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Some times the faulting module is vbe6.dll rather than ntdll.dll, but the problem stays the same regardless.

Anyone have any thoughts on this?



It seems to me that once we get this error some DLL on my system is corrupt or is conflicting with another and causing the “close out” problem.  The weird thing is that some systems work fine while others have this problem consistently.  While rebuilding the systems I have tried all different service pack levels and patch levels, nothing seems to make a difference.

I have tried rolling back the database to an older version about a month ago, before we started having this problem.  So far that older database does not seem to make any difference, but I continue to try different scenarios with it to no avail.

Is it just me or is Access not really all that stable of a development tool? (don’t answer that)

Any help I could get on this issue would be greatly appreciated.
0
Comment
Question by:ctrunk514
  • 4
  • 4
8 Comments
 

Author Comment

by:ctrunk514
ID: 11824681
hmmm ... no responce, not a good sign.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 11824849
Hi ctrunk514

I subscribed to this Q hoping someone will pop in so that I benefit too,

Let me tell you my case,
We have in our office identical PCs and the same OS and Office 2k,
and No problem.
PIII, WinME, Office 2k.

The Account is using his oun accounting package, besides our developed project tracking mdb,
he started getting these error messages, they took turns between the accounting package and Access, with different messages, including systems,
the fix was a format and reinstall everything back,
a month or 2 later the same problem,
Then I had to move him to WinXp pro, on the same PIII PC with office 2k,
No problem for about 6-9 months, then it started again,
Looking deeper in his PC, No virus, but I could find some of the internet spyware,
I removed it along with all the unnesssacery stuff,
Well the PC is back to normal again, for how long?

So I guess its a matter of what's in that PC.
Sometimes a Bad hardware can cause these problems too, especially the NIC.

Although I hate formating, but nothing better than a nice Full format and reinstall ONLY minimum software, AND instructing the user not to install anything.

I hope this piece of experience will help,

jaffer
0
 

Author Comment

by:ctrunk514
ID: 11832537
I have tired re-installing many times, sometime it helps and somestimes it does not.

The problem seems to work on some hardware and not others.  I would agree with the dirver theory but except that this problem started happening on 2 PC all al the same time.  Nothing had change on thouse PC which had been working with this access database for many months.

It kind of seems like some DLL's are conflicting and causing this problem.  Im not sure what is causing the crash that starts the DLL's to conflict but once we get that crash access is hosed.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 27

Expert Comment

by:jjafferr
ID: 11832651
Did you upgrade/update Windows OR any other software on those machines?
OR install any program?

Even Google bar or Yahoo bar might case the problem.

Well, our accountant is the kind who installs things on his PC without telling me, so you know what I mean.

Can you run another Access mdb on these machines and see if they crash, lets try to isolate the network from the problem.

0
 

Author Comment

by:ctrunk514
ID: 11854818

I can not explain why this just all of a sudden started happening but what ended up being the problem was the default printer driver.  I know is make not sence, but for whatever reason this driver must have changed on my problem systems and for some reason Access did not like this new driver.

The problem would happen when we ran reports that would auto email, which needs the printer for some reason.

It was a fluke that we even figured it out, but it seems to have solved the problem.  
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 500 total points
ID: 11855035
Good news,
remember what I said: "Sometimes a Bad hardware can cause these problems too"
And the problem is that, you really cannot figure it out, unless you have a very close watch of what is happening.

Thanks for sharing this piece of info with us.

jaffer
0
 

Author Comment

by:ctrunk514
ID: 11855057
It was more the driver as apposed to the hardware, but I will  give you the points anyways.  You were the only one that responded.
Thank you
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 11855079
Well, its the chicken and the egg stuff.

Thanks for the points anyway.

I learned something new too.

jaffer
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

685 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