I have an Access 2007 db which has many different forms that are open simultaneously on the stations of different users. We constantly run into locked records because of it.

Is it possible to use the timer to send ouit a global refresh command to all forms on each user's station, say every minute? That way all records will always be current up to that moment.

I know it can be done for each form, but it would require each form to get the focus once a minute to run the refresh command, which would destroy productivity.

Any assistance would be appreciated.