• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1467
  • 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?
0
internetcreations
Asked:
internetcreations
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.
0
 
internetcreationsAuthor Commented:
The same thing happens when the FE is on the computer's local drive, although seemingly with less frequency.
0
 
internetcreationsAuthor Commented:
This was related to Office 2007 SP2. Microsoft provides a rollback for this SP2 which resolved the issue.
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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