Hi all,

I encounter this problem on backup a mdb (access db) on let say every 12 am midnight using excel vba or access feature maybe.

Thanks

I have tried FileCopy in excel VBA, it works when db is not in lock. and i use excel autosave feature, i trigger the back up before my workbook save itself, but the time i can only set it max 120 mins save once.

But i would like safe only one time which is 12 am at midnight. Any idea?

Thanks