Frequent "Updating tables" message in front end using Access 2007

We have an Access front end running off a network share with about 20 users. Until recently, all users have been using Access 2003 and there have been no major problems. A few users now have new machines with Access 2007. These users frequently (upwards of every 5 seconds at times) get a message in the status bar "Updating tables. Press and hold ESC to stop...". Sometimes this message flickers so fast that it can barely be seen, and other times it will remain for 10 seconds and completely lock up Access. The machines with 2003 still work completely fine. The only difference I can see is the version of Access. I looked around online yesterday for info on this issue and came up dry. Anyone else come across this? How can I go about resolving?
LVL 1
internetcreationsAsked:
Who is Participating?
 
internetcreationsConnect With a Mentor Author Commented:
This was related to Office 2007 SP2. Microsoft provides a rollback for this SP2 which resolved the issue.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Have you deployed a copy of the FE to EACH of those users? This is the recommended method for doing this.
0
 
internetcreationsAuthor Commented:
The same thing happens when the FE is on the computer's local drive, although seemingly with less frequency.
0
 
gaynesCommented:
Did you ever find a real solution to this? I am having the same issue. Thanks!
0
 
SaMMaSCommented:
I had the same problems however we found out that this is related to the environment and not to the database itself. The same database was doing this on Microsoft office SP2 but not microsoft SP1
Will try to roll back office from SP2 to SP1 to see if it resolves the problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.