Autodelete on specific date

Is it possible to make Access 2000 autodelete a post?

When a new post is submitted, it autoinsert todays date into a date field. If that post isn't confirmed by setting a true/fault field to true later, I wan't that post to be automatically deleted after 10 days.

Is it possible to write some scripting in Access that does this?

The Database is "talking" to a ASP-webpage, if it isn't possible to do this in Access, can this be done automatically with ASP, or do I have to do this manually?

Thanx in advance.

EiSa

What you might want to do is schedule a job to run each day, to check the database for any posts that are greater than 10 days old and not confirmed and then delete them.

check out this list of links in my post, that describe how to schedule a script

http://www.devarticles.com/forum/sh...s=&threadid=621

Hope that helps.