Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Faulting application msaccess.exe --HELP--

Posted on 2004-08-17
8
Medium Priority
?
5,639 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

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.

Question has a verified solution.

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

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…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

916 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