Solved

Access Hanging

Posted on 2003-10-28
7
672 Views
Last Modified: 2010-08-05
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
0
Comment
Question by:Wafu
7 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 9632968
What is Access SP4?

There is no public SP4 release for Access.

Pete
0
 
LVL 8

Expert Comment

by:HaydnH
ID: 9633063
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
0
 
LVL 8

Expert Comment

by:HaydnH
ID: 9633067
Also, what SR is the lap top version of access?
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 8

Expert Comment

by:HaydnH
ID: 9633161
You may also want to run a mem test - http://www.memtest86.com/memt30.zip

Haydn.
0
 
LVL 2

Accepted Solution

by:
ultimatemike earned 500 total points
ID: 9633215
Is it always the same database that this happens on? Try going to Tools -> Database Utilities -> Compact and Repair. That might fix the problem.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 9993072
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
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now