Need delete some records from MS ACCESS automatically.

[kishore22]

Hi,
I need to delete all records that are 6 months old. these records should delete from the MS ACCESS database automatically. Every record will have the date on which they are entered.

Are there any triggers allowed in Access database that runs daily to check whether the records are 6 months old or not?

thank you,
Kishore

 

[lhite]

You could create a Delete Query and set the parameters to delete any record where the date exceeded 6 months, then name it AutoExec so that it runs every time the database is opened.