Connecting Tech Pros Worldwide Forums | Help | Site Map

archiving files of previous months in Access

Newbie
 
Join Date: Jul 2006
Posts: 1
#1: Jul 31 '06
I have created a form in MS Access which updates some files for each month. I would like to archive the files of previous months and keep them as records that can be accessed. and i don't know how I can do it :confused:
greatly appreciate your help and advice

Familiar Sight
 
Join Date: Jun 2006
Location: Edmonton, AB
Posts: 179
#2: Jul 31 '06

re: archiving files of previous months in Access


You should be able to programatically create a table (either in current or in another database), populate it with the files you wish to archive by using an "UPDATE" query, and then delete the records of the original table.

comteck
Reply