请教:如何设定数据库中的信息保留时间?

[xixuanfong]

我现在正在做一个供求信息类的网站,老总要求所发布的供求信息只能保留一个礼拜,一个礼拜后自动删除,我后台用的是access2000,前台开发用的是dreamwever ultradev4.0,请问大虾该如何实现?
供求信息表:
表名 gqxx
字段有:id(供求信息编号),type(类别),content(内容),date(发布日期),title(标题),name(发布人)

最好给我一段程序

万分感谢!!

[ttt2]

sql
select * from testyear where datediff(d,adate,getdate())>7
access
select * from testyear where datediff('d',adate,date())>7

[ttt2]

sql
delete from testyear where datediff(d,adate,getdate())>7
access
delete * from testyear where datediff('d',adate,date())>7

[xianglong]

delete * from testyear where datediff('d',adate,date())>7