I am trying to setup a function that automatically deletes records older than todays date using asp with an access database.<BR>Does anybody have any ideas?<BR><BR>Simon :)
And an ASP page/script that's scheduled to run at 12:01 AM.
DELETE FROM table where somedate < Date()<BR><BR>I don't think Access stores times, so this should do it.
Does anybody else think God is funny???? Yeh baby!
Thanks but what I want to do is have a function that runs automatically each day that takes the current date and deletes all records older than the current date.<BR>