Solved

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

Posted on 2012-12-27
7
493 Views
Last Modified: 2013-01-28
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
Comment
Question by:Kevin Smith
[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
  • 3
  • 2
  • 2
7 Comments
 
LVL 9

Expert Comment

by:newmath
ID: 38724789
Have you re-compiled and compacted the front-end DB?
0
 

Author Comment

by:Kevin Smith
ID: 38724797
Yes I have.
0
 
LVL 9

Expert Comment

by:newmath
ID: 38724813
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
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 74

Expert Comment

by:Jeffrey Coachman
ID: 38724896
<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
 

Accepted Solution

by:
Kevin Smith earned 0 total points
ID: 38767360
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38770403
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
 

Author Closing Comment

by:Kevin Smith
ID: 38826138
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 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