I have had a number of old Access DBs dropped in my lap and ever since Office 2007 SP2 was installed on all our machines they have been having frequent messages on the status bar saying: "Updating tables press and hold esc to stop". They eventually start hanging longer and longer causing the DB to freeze for minutes at a time for each user.
I've been looking everywhere for a solution and am getting a little tired of the split-the-db 'solution'. It might be an adequate workaround but it doesn't address the underlying cause. I understand that individual front ends for each user might be optimal it still doesn't explain why there weren't any problems prior to SP2. Management isn't willing to provide more project time to splitting, distributing and updating every DB for a problem that was never a problem before nor will they roll back SP2 just because of a bug in Access.
I have split a test copy of one of the DBs and even the split copy flashes the message frequently in the status bar for both the front end and back end. Whatever is causing these constant updates might not be very noticable when each person is accessing their own copy but it still exists.