I have a split database with multiple tables and multiple users.
Is there a way, other than date/time, to tell if any data has been altered.
The back end date/time can be stored in a tempvar but the time changes if the data is viewed and not necessarily changed.
The previous day's data is automatically backed up when the first user logs in on the next working day.
I would like to trigger another back up when the last user logs off, if the data has been altered and not just viewed.
I know it's a bit "belts and braces" but sure is better than sorry.
Is there a way, other than date/time, to tell if any data has been altered.
The back end date/time can be stored in a tempvar but the time changes if the data is viewed and not necessarily changed.
The previous day's data is automatically backed up when the first user logs in on the next working day.
I would like to trigger another back up when the last user logs off, if the data has been altered and not just viewed.
I know it's a bit "belts and braces" but sure is better than sorry.