Solved

Faulting application msaccess.exe --HELP--

Posted on 2004-08-17
8
5,510 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
[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
  • 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
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!

 
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

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!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 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