Users need to close and restart to see records

[Flick Olmsford]

My users in a small dept (5-6 people) claim that they need to close Access
and reopen the database to see a record added by another user while they were
simultaneously logged in before.

Why would this happen?

Server: Windows Standard 2003 with 30-40 network users;
Win XP Connected workstations, all running Access 2003

 

[John Spencer]

They should not need to close and restart. The program does need to have a
way to refresh the data.

For instance, I have one application that is always open to the same central
form. The form has a button that has VBA code that uses the requery command
to refresh the form data.

Sub someButton_Click()
Me.Requery
End Sub

You could do something similar using a timer event. However, you would not
want to do this while the form was being used to enter data, so you might want
to check the form's dirty property to make sure you were not going to requery
the data in the midst of a record update or record entry.




John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Arvin Meyer [MVP]]

The record may not be saved if it is still in the user's open form. In order
to see what's been added to the table, you must refresh the data. In each
person's options change the refresh rate, in seconds,

Tools >>> Options >>> Advance >>> Refresh Interval

the default is 60 seconds (depending upon the version) you can change it to
whatever you think is reasonable. Keep in mind that it does add overhead,
and it won't help if the record hasn't be saved.

 

[Stockwell43]

Hi Flick,

Not a problem. Create a button call it cmdRefresh(or whatever you want to
call it) in the OnClick Event click on the three dots to the right ... and
when the window opens type Me.Requery and that should do it.