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
Wm. Kent Steelman