Solved

Faulting application msaccess.exe --HELP--

Posted on 2004-08-17
8
5,450 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

827 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