i have a table that is linked to another access file on the same pc,i run a querry to filter the table,i use an on timer event procedure to refresh data every 20 seconds (20000ms),this works fine when the two file are on the same pc but i put one of the them on another pc and update the link,i get an error when the refresh happens "The expression On timer you entered as the event property setting produced the following error: * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro.
the code i use as the event procedure is
Private Sub Form_Timer()
Me.Recordset.Requery
End Sub
the timer is set to 20000ms
what could be the cause of the error
thanks