automated data archiving 1

[davejoyce]

Is there a way to automate the archiving of data in an access database?<br><br>For instance, everyday at midnight all rows in a table are copied to another table.<br><br>The only way I can think of doing this is to check a table to see the last time the table was update each time a user enters a particular page. If the time is greater than 24 hours, update the data and set the time in the table.<br><br>This may create delays for the user.<br><br>Any other suggestions??<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thanks,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dave

 

[TamHonks]

Dave -<br><br>Write your routine to copy the data to another table, and then set up the template as a 'scheduled action'.<br><br>I'm pretty new to ColdFusion myself, and haven't done this yet, but remember reading that you can arrange for templates to be executed at regular intervals... Check out 'scheduled actions' in the CF administrator... And let me know if I'm wrong about this!<br><br>Yours -<br><br>Tam.<br>

 

[davejoyce]

TAM,<br><br>&nbsp;You were correct. It can be done in the administrator or by using the CFSCHEDULE tag. Works well.<br><br>&nbsp;&nbsp;&nbsp;Thanks,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dave Joyce

 

[DarkMan]

Tam's right.&nbsp;&nbsp;Just set up a template then add it to your scheduled tasks in the CF administrator, or if you don't have acess to the adminstrator, you can use the CFSCHEDULE tag.