Automatically delete data after this many days

[sriky]

Is it possible with Access? or do we need sql server? I also need to adjust the time interval in the data base after pre defined time limits.

Any help appreciated

Thnaks

[ariaz]

yes offcourse you can do there are several method to do
1- define the interval in days and write in text file when your application run you read the file and check the period if period is greater than define interval then delete the data
2- In access database you create two feild start date and end date calculate days at run time if greater days then delete data.

Plz if answer is fulfill your requirement then mail me ariaz@brain.net.pk

or other wise revise your problem with deatail
thanks