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

Kevin Smith
Kevin Smith used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Have you re-compiled and compacted the front-end DB?

Author

Commented:
Yes I have.

Commented:
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?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
<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
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.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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

Author

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.

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