Automatic deleting of the data from a table

[n0nick]

How can I make MS Access to automaticly, for example every sunday in the week, delete all data(posts) in one spesific table. Lets say I have one table named Table1 and got fields sessiondID, productID and date.

I want that MS Access deletes all stored posts until todays date.

Sorry if my english is bad

 

[SJMcAbney]

Create a delete query with the criteria you need. Create a macro called autoexec that turns off warnings, runs the query, turns warnings back on, and closes the database.

Use Windows to schedule task for weekly automation.

Stewart J. McAbney | Talk History

 

[n0nick]

Hello! Thanks alot for your answer. It did work like i wanted it but, when I connect to this Database using ASP will macro "autoexec" also then automaticly run at startup, or does this macro only runs when you open Access database with MS Access?

 

[SJMcAbney]

Only when you open MS Access. You didn't say anything about ASP in your initial post - how was anyone to know?

Stewart J. McAbney | Talk History