Article ID: 186577
Article Last Modified on 1/23/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q186577
SYMPTOMS
The data in a form will refresh when the form is first opened, but after the form is open a few minutes, it will not refresh.
CAUSE
You have a form that is based on a linked table and the Refresh Interval is set to a low number (fewer than five seconds.)
RESOLUTION
To resolve this problem, obtain Microsoft Office 97 Service Release 2 (SR-2).
For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:
151261 OFF97: How to Obtain and Install MS Office 97 SR-2
To temporarily resolve this problem, use either of the following methods.
Method 1: Increase the Refresh Interval
You can avoid this problem by using a longer Refresh Interval. To change the Refresh Interval, follow these steps:
- On the Tools menu, click Options.
- Click the Advanced tab.
- In the Refresh Interval(sec) box, type a number larger than five.
- Click OK.
Method 2: Use the Timer Event
You can use the Timer event to force the form to refresh the query results. To do so, follow these steps:
Type the following code for the form's OnTimer property event procedure:
Private Sub Form_Timer() Me.Requery End Sub
- Set the form's TimerInterval property to the desired time interval.
NOTE: The time interval is measured in milliseconds. For example, to get the form to requery every second you would type 1000.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).
Additional query words: high low
Keywords: kbbug kbfix KB186577