Solved

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

Posted on 2012-12-27
7
489 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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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 Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 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