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.