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?
Microsoft AccessMicrosoft SQL Server
8/22/2022 - Mon
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!