Dear Richard,

I have successfully written a code for new users to activate their product (Access database) and old users to renew their license at the end of the year. On the date they activate their product, i add 365 days so i have both the start and end dates of the license period.
There is one challenge though. Suppose the user changes his computer date (backwards or forwards), how do i utilise the dates that i have in the system to check if the user's license is still valid or not? I am so far failing to work out the logic.

I can share this code with my fellow students who may be interested.

Best regards,

MICAH

---

Reply from Richard Rost:

Well, there's nothing you can do to prevent them from changing their system date, but hopefully they won't because it will mess up the dates in their reports (assuming your data is date-sensitive). However, you could do something sneaky, like save the date that the software is run each time the database loads. Keep it in a hidden table. Then, the next time the database loads, look and see if the current date is LESS than the last load time. If it is, lock the program up and tell them to call customer service. There's ALWAYS a way around a problem like that. :)