I am currently working on a database system (Access) that stores results of employee assessments. I would like to include in this system a facility for the administrator to backup (eg output to .csv or .dbf files) all records created before a certain date, removing these records from the system as they are backed up.
There should also be a facility to restore from this backup file should it ever become necessary.
In total, there are 5 tables (all related) to be backed up.
I would be extremely grateful if anyone could reccomend the best path to take in order to achieve this task.
Thanks in advance,
Mad Jock
There should also be a facility to restore from this backup file should it ever become necessary.
In total, there are 5 tables (all related) to be backed up.
I would be extremely grateful if anyone could reccomend the best path to take in order to achieve this task.
Thanks in advance,
Mad Jock