Help with Auto Delete at a given time

[dponce]

Best regards to all,

I am new to this form and site, not to mention I am a beginning MS Access developer. This software came install on my laptop and seems to be pretty cool programming software. I have been playing around with this for 2 months and have been putting together some simple data bases just to learn what I can.

What I am needing help in is I am trying to find away that I can tell the program to delete all the records found on a given table at a certain time during the day. More like midnight.

I was thinking that something like this could be done with using the "On Timer" event procedure in the Form or would like need script in order to accomplish this? Any help or direction would be appreciated.

[ADezii]

Best regards to all,

I am new to this form and site, not to mention I am a beginning MS Access developer. This software came install on my laptop and seems to be pretty cool programming software. I have been playing around with this for 2 months and have been putting together some simple data bases just to learn what I can.

What I am needing help in is I am trying to find away that I can tell the program to delete all the records found on a given table at a certain time during the day. More like midnight.

I was thinking that something like this could be done with using the "On Timer" event procedure in the Form or would like need script in order to accomplish this? Any help or direction would be appreciated.

Try creating a Scheduled Event which would open a specific Access Database at the indicated time. Create an AutoExec Macro that would run a Delete Query on the specific Table then exit the Database.