Create backup mdb file at open or during the day.

[jdttek]

I know that Access mbd files do not have a "Save As" or back-up capability. Other than nitely system backup, is there any way to automatically copy the file on open, or during the course of the work day, to a seperate directory so that during the day, if the file becomes corrupted, user inputs wrong data or, worse yet, user deletes data, you can go back to to the backup copy to restore.
Since records save on close of record, if a record is deleted or critical info is changed by mistake and the form is closed, then the error is final. I want to be able to reverse this if necessary.

Any help or experiences on how to reverese input errors or restore corrupted file from backup wld be greatly appreciated.

Thanks
JDTTEK

 

[thegameoflife]

[ul]

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209979

[/ul]


This will work for the backup.