• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

Access frontend gets hung on"calculating..." and never fully loads data

I have an Access 2007 frontend that connects to a sql server 2005 backend.  Everything's been working just fine, but now one user (XP) will open the frontend (on everyone's machine) and it'll hang up.  The status bar will stay on "calculating..." forever (well, seems like forever).  I deleted out all the linked tables and put them back in, but it even does that very, very slowly.  I even deleted the odbc connection and made a new one...same thing.  What should I look at?
0
Kevin Smith
Asked:
Kevin Smith
  • 3
  • 2
  • 2
1 Solution
 
newmathCommented:
Have you re-compiled and compacted the front-end DB?
0
 
Kevin SmithAuthor Commented:
Yes I have.
0
 
newmathCommented:
Hmm, ok, what happens when you try to link tables from fresh DB? Is it still slow. Sluggish SQL connections can point to all sorts of issues. The SQL server itself may be the issue. In that case, you would need to check network saturation, disk access, etc. - system resources. Also, check the event log of the SQL server itself. See anything strange?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Jeffrey CoachmanMIS LiasonCommented:
<now one user (XP)>
So this is only for this one user?

< will open the frontend (on everyone's machine) and it'll hang up. >
So this issue follows the "User" to each workstation...?
Make sure this rogue user has all the exact same permissions as all the other users.

JeffCoachman
0
 
Kevin SmithAuthor Commented:
I did a restore on the user's workstation and it fixed the problem.  I have no idea what it was.  I don't know how to award points on this.  Both were good suggestions, but with restore fixing it I'm not sure what the problem was.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then "your" post above is the solution...
;-)

You can accept your own solution as the answer, as this will better help other members searching here with the same issue.
;-)

Enjoy the weekend.

Jeff
0
 
Kevin SmithAuthor Commented:
The answers provided did not fix the problem, but restoring it did.  It was suggested that since that fixed the issue, then it'd be better to choose my own comment as the solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now