Ok my database collapsed the other night and after putting together a backup file a bit old and a more recent excel extraction I could retrieve 98% of it.
I use this databse everyday, 10 hours a week, is there a way to schedule an automatic backup at a given frequency (every week for example) in a given folder?
Can we also automate a maintainance run (compact and repair) each time I close access?
Thanks