I woudl like to be able to set a time limit for a record to be accessed. After the timie limit has been reached the record is deleted. Anyone have ideas?
In your table definition declare a column of type date/time, (datCreated), with a default value of Date() Or Now(), use Date() if you just want to delete based on days old, if yo want to go down to hours or minutes use Now()
As part of your start up of your database run a query to delete all records older thatn specified time eg
DELETE * FROM MyTable WHERE datCreated <= DateAdd("d",-1,Date())
to delete all records 1 day old or older
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.