I am testing 2 simple access applications on the same computer.
The first application, after pressing the button, writes ActualTime = Now into its local table tbl.
The second application uses this tbl table as a linked one. The form in the Form_Timer (100ms) reads the ActualTime entered by the first application, detects its change and calculate delay
The problem is that the second application detects the change of the entered data only after a delay of 1 - 5 seconds from the time of its entry.Code:Private Sub Form_Timer() rstData.Requery If Me.ActTime <> rstData!ActualTime Then Me.ReadAt = Now Me.ActTime = rstData![ActualTime] Me.Delay = Now - rstData![ActualTime] End If End Sub
Is there any possibility to detect the change of the data in the linked table immediately after its entry by other access app?