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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automate archiving
- Thread starter 1starr
- Start date
I setup the following procedures for a database I worked on....
I created a separate database to hold my archived data. I copied the data table to this new database and emptied it so I know the structures were identical. I created a link to the archive table in my main table. I then created an append query that selected any data older than three months and with a closed status (these were customer calls) from the data table and appended it to the archive table. I followed this with a delete query against the data tablewith the same criteria. At first this was a button on an administrative type form I had, but I eventually create some code that ran everytime the db opened to perform these two qeuries....
Simple and effective. ****************************
Only two things are infinite, the
universe and human stupidity, and
I'm not sure about the former.
(Albert Einstein)
Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com
I created a separate database to hold my archived data. I copied the data table to this new database and emptied it so I know the structures were identical. I created a link to the archive table in my main table. I then created an append query that selected any data older than three months and with a closed status (these were customer calls) from the data table and appended it to the archive table. I followed this with a delete query against the data tablewith the same criteria. At first this was a button on an administrative type form I had, but I eventually create some code that ran everytime the db opened to perform these two qeuries....
Simple and effective. ****************************
Only two things are infinite, the
universe and human stupidity, and
I'm not sure about the former.
(Albert Einstein)
Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: robert.l.johnson.iii@citigroup.com
h: wildmage@tampabay.rr.com
- Status
Similar threads
- Locked
- Question