Access frontend gets hung on"calculating..." and never fully loads data
Posted on 2012-12-27
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?