• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1474
  • Last Modified:

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?
1 Solution
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.
internetcreationsAuthor Commented:
The same thing happens when the FE is on the computer's local drive, although seemingly with less frequency.
internetcreationsAuthor Commented:
This was related to Office 2007 SP2. Microsoft provides a rollback for this SP2 which resolved the issue.
Did you ever find a real solution to this? I am having the same issue. Thanks!
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
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.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now