I currently have a split database with time sensitive data. The data is locked after 2 weeks, leaving the users a 2 week window to enter/update date. The problem was pointed out that if a user changes there system clock on their PC to an older date, MS Access is using this to set the current date on the frontend. This is leaving the database open to change outside that 2 week window.
Any ideas how I can capture the actual date or the server...