?
Solved

Access Hanging

Posted on 2003-10-28
7
Medium Priority
?
679 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

764 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