Access Hanging

Wafu
Wafu used Ask the Experts™
on
I have a problem on an XP Pro machine, it's fully patched , clean of Virus's and in all other respects works ok. The problem is on Access 2000 SP4 . When I open a database all is fine , but the minute I open a table the program hangs in a massive way and generates the following error in the event log

"Source : Application Hang"
Category : (101)
Event ID : 1002
Type: Error
Description: Hanging Application MSACCES.EXE Version 9.0.0.6620, hang module hungapp , version 0.0.0.0 hang address0x00000000.

I've re service packed Office , un installed and re-installed Access, all to no avail. Will it be neccessary to re-install the whole Office Suite?

I'm getting in  the neck from the user involved , so a solution will be very welcome, hence the points.

One last point, the Databases are on the machine itself, and when I run the on my laptop they work perfectly.

Many thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What is Access SP4?

There is no public SP4 release for Access.

Pete

Commented:
Has the problem just appeared and was it working previously? You could try using the windows restorer and rolling back to the previous SR of access.

Haydn

Commented:
Also, what SR is the lap top version of access?
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

Commented:
You may also want to run a mem test - http://www.memtest86.com/memt30.zip

Haydn.
Is it always the same database that this happens on? Try going to Tools -> Database Utilities -> Compact and Repair. That might fix the problem.

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: ultimatemike {http:#9633215}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

stevbe
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial