Forums

This topic is locked

Automatic Deletion of Records

Posted 21 Jan 2002 08:41:21
1
has voted
21 Jan 2002 08:41:21 Jason Money posted:
Is there any way to set records either in Access or in UltraDev to automatically delete certain records at certain times?

I'm doing a website for a band, and I want to have the shows appear on a certain page, but I want them to delete themselves the day after the show takes pace. Can anyone help me out with this? Thank you.

Replies

Replied 21 Jan 2002 14:30:36
21 Jan 2002 14:30:36 Kent Steelman replied:
A web site I designed, does this in the followng manner. When the convention (in your case the show) is added to the Database, a record expiration data is entered into the record. When someone goes into the database the query only displays those records in the database where the record expiration data is >=now() in access. This does not eliminate the record, but filters only those desirable. On the clean up side (Adminstration) we give the site owner/admin person the ability to view all expired records and then delete them.

Wm. Kent Steelman

Reply to this topic