Question Automatically add new record on a specific date?

[Mohsin Malik]

Is it Possible to automatically add new record to the table on a specific date? Basically i have a expiry date in table, i want ms-access to automatically add new record when system date reach to the expire date. For automatically added new record, i want to set the contract start date by default as the expiry date of the previous record? Any idea how to do this? thanks

 

[MarkK]

What you can do is write a stand-alone database that runs code when it opens and then shuts itself down. Then schedule it to run as a windows task.

Or you can run a timer in your application, which is sort of a pain.