Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Archive Data from Tables Automatically

Status
Not open for further replies.

rsatty

Programmer
Nov 15, 2003
21
US
Can someone tell me how to set up my database to automaticall Archive data from my tabels every 90 days.
 
Create a table to hold the LastArchivedDate
Create a splash screen to open at startup.
In the Timer event check the difference between Date() and LastArchiveDate
If it's 90, do your stuff
Update LastArchiveDate to current date.

Good luck


[pipe]
Daniel Vlas
Systems Consultant

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top