Message Updating Tables. Press and Hold ESC to stop.. in Access

[Juliet]

I have a shared database with Access 2007 that keeps freezing and unfreezing.
The message on the bottom of the screen bar says "Updating Tables. Press
and hold ESC to stop"

We cant get any work done because eveyr time this message flashes the
database freezes up. It happens every 5 secones!! HELP!!

[Jerry Whittle]

Where is the databases file located: on your PC or out on a network?

How many users are on it at once?

Is it split to where the tables are out on a network and the forms and
reports are on the user PCs?

Any fancy code running on a Form's Timer Event?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

[Juliet]

The database is located on a network and there are 5 - 8 users at once. It
is split but both copies reside on the server and we have shortcut's on our
desktop to the front end.

I don't think there is any fancy code, just the usual.

[Jerry Whittle]

You need a copy of the Front End on each user's PC. That single FE out on the
network is likely the problem.

[Juliet]

I thought you might say that. So would you be able to give me some
instructions on how to do this?

Also, if they work on a copy, what steps would I need to do at the end of
each day to get the original database updated from the copy they are working
on?

[Jerry Whittle]

Just to get the terminology right, by split I mean that the same database
application is split into two files. One, the back end, has just the tables
while the other, the front end, has the forms, reports, and everything else.
This is different than two different database applications, such as one for
Employees and the other for Sales, where different people use them.

In the split database the Back End (BE) stays out on the network. All the
users put data into the same BE. Therefore there isn't a problem with
synching up the data.

Now for the FE. I place a copy of the production FE out on the network where
all users can get to it. I don't allow them to use it. Rather during the
startup of their computer it is copied to the PC either through a login
script or something in the Autoexec.bat file. This way when booting up in the
morning, the users get the latest and greatest. Also if their FE corrupts for
some reason, they are only a reboot away from a fix.

[Juliet]

Jerry your help has been invaluable, thank you very much! I am trying out
your suggestions today on the users PC's.

[joshua yeoman]

"Juliet" <Jul...@discussions.microsoft.com> wrote in message
news:443BEC25-5F4B-4BE6...@microsoft.com...