ACC97: Form May Not Refresh with a Short Refresh Interval

ID: Q186577

The information in this article applies to:


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:

Q151261 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:
  1. On the Tools menu, click Options.


  2. Click the Advanced tab.


  3. In the Refresh Interval(sec) box, type a number larger than five.


  4. 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:
  1. Type the following code for the form's OnTimer property event procedure: 
    
      Private Sub Form_Timer()

         Me.Requery

      End Sub


  2. 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          : FmrProb 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 16, 1999