Auto delete

[Nick]

Is there a way to delete data automaticly when the data base is closed. I
currenty have a manual button that deletes data, date minus 30? When the
database closes it does compress the files the tables automaticly. I would
like to do it all when the database closes.

 

[Douglas J. Steele]

Have a form that opens up automatically when the database opens (it can be
hidden if you don't have any other need for it). In the Unload event of that
form (or the Close, I suppose), put logic to run your delete queries.