hi all

Is it possible to automatically delete a record after 2 weeks (access)??

I need to do this if a user hasnt confirmed their membership within that period.

Thanks

Dave

ASP|VBScript|IIS5.1|WinXPPro & WinXPHome

Okay
I can create this command

<b>DELETE FROM accessgroups
WHERE ((accessgroups.fldjoined&lt;Date()-14)) AND fldGroup = 'Guest' </b>

I created it without checking the "return recordset named" box, is this correct?

What do i do with it??

Do i put it on one page, all pages, some pages or what??
Will it run everytime that page is opened??

thanks
Dave



ASP|VBScript|IIS5.1|WinXPPro & WinXPHome

Edited by - Davecl on 14 Oct 2002 19:58:29

One option if you don't have the ability to set up something on the serever itself is to set up a web page that deletes all records older than 2 weeks as you have then call it from task scheduler on a local computer that you can leave on all the time and will open the browser at the page you have set up each night.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

cheers Owen

I've put the command on the home page, so hopefully that will update the database as often as i need it to.

Dave

ASP|VBScript|IIS5.1|WinXPPro & WinXPHome

The home page is probably overkill, why not on the conformation or login page?

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

mmmm, maybe right there owen, home and login on same page so maybe confirmation page, will have to think about it.

thanks

Dave

ASP|VBScript|IIS5.1|WinXPPro & WinXPHome