Ensure fresh data
Posted on 2013-02-05
I have table "TIger" that every minute imports new records from a .csv file.
I would like to test the data to ensure that it is current (within the last 30 minutes) based on fields "obs_date" and "obs_time", which are a medium time, and short date field (respectively).
If the data is older than 15 minutes, I would like to pop up a message box that states: "Reset link software immediately".
added bonus: The message box should close after 5 minutes if not acknowledged; that way if the software gets reset while I'm not at the database computer, we can continue processing.
If the solution involves vba, please include at the bottom how to call it from a macro. I will be running the macro every few minutes.