Access hangs at random

[Preka]

Think I've posted about this before with no luck. Googling hasn't returned much either, at least with relation to Access.

One of the machines in the office gets random application hangs while using access.

Event viewer shows:

Hanging application , version 0.0.0.0, hang module hungapp, version 0.0.0.0,
hang address 0x00000000.

It locks to the point where I can't even kill the process via task manager. The error reporting prompt eventually shows but the process remains.

It's getting pretty frustrating, as the lack of any type of specific information about the hang doesn't leave me much to work with.

Any ideas would be much appreciated.

 

[markphsd]

This is something that sounds less like access and more like either a corrupt file, or conflicting files. Maybe if you re-install access. It can also be caused by not all of the updates for windows applied. Try applying all of the most recent updates.

Also, try to determine the difference between this machine and the others. That might show a resolution.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[Trevil]

Questions:
1. Any clues from Task Manager? (looking at CPU, I/O Reads, I/O Writes & I/O Other
2. Is your network involved? i.e. is the database on your server or tables on the server?

If all else fails, and there are a limited number of forms and transactions, you could add a "Timer" subroutine that writes info to a log file/table. Once upon a time, I added start/stop timers for every subroutine to diagnose performance hot-spots.

"Hmmm, it worked when I tested it....

 

[Preka]

<<1. Any clues from Task Manager? (looking at CPU, I/O Reads, I/O Writes & I/O Other
2. Is your network involved? i.e. is the database on your server or tables on the server?>>

The tables are located on a server, the front end is a local .mde file.

Was thinking of trying a re-install, that's next. Just wanted to check here first and see if anyone had any ideas.

The only reason I think it's access related is that's the only app that hangs - nothing else seems to.

 

[DaOtH]

> The only reason I think it's access related is that's
> the only app that hangs - nothing else seems to.

Are network issues preventing the frontend reading it's backend access related ? Surely that could very well be the case.

&quot;In three words I can sum up everything I've learned about life: it goes on.&quot;
- Robert Frost 1874-1963

 

[Preka]

<<Are network issues preventing the frontend reading it's backend access related ? Surely that could very well be the case. >>

I could see that possibly being the case, yes. I'm not much of a networking guy, beyond the basics of setting one up. Any tips on how to test to see if that's the case?

 

[Trevil]

I was investigating network traffic and downloaded a trial version of DU-Meter (

http://www.dumeter.com)

It has a 'stopwatch' plus will show traffic going in both directions. With that, I was astounded at the amount of data that was going across the net -- was easy to pinpoint why things were slow!



"Hmmm, it worked when I tested it....