I have this app that monitors data on a client 's networked system. The network is NT4 with servicepack4. My form has a timer set to 5 seconds. The timer event has a select that gathers data from tables stored on a machine on the network and displays a graph of this data. Also it tracks the movement IN & Out of trucks to different locations on the factory. I have this info in a table in a DBC. Other processes write to this table and my app wakes up every 5 seconds and does a select on this table to display the data, and redraw the screen with this.

I have found that the data being fetched is not current. I have set reprocess to 5 seconds and refresh to 5 seconds. But the data is not being refreshed.

The user can click on a picture of a truck on the site(on my form) to get more info. But on clicking sometimes they get no data as the truck has moved and the select did not get this data.

How do I make sure that the data I am looking at and SELECT is the current one. How do I get a proper "REFRESH" of DATA without closing and reopening the table??

Bernard