Forums

This topic is locked

Automatic Deletion of Records

Posted 23 years ago
1
has voted
23 years ago 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 23 years ago
23 years ago 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