?
Solved

Faulting application msaccess.exe --HELP--

Posted on 2004-08-17
8
Medium Priority
?
5,675 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

621 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