Hi all
I have a split database that is currently making a copy of the back end via an autoexec macro. It also adds a record to a backup table with dates, user, etc. It looks at the table first to see if a record with the same date exists and if it does exist, the back up does not occur. In essence it makes a daily backup.
It gives the filename as such "GEIR_BACKUP_YYYY_MM_DD.accdb". What I would like to do is add to the autoexec macro so that it looks in the folder and deletes the previous backup. I do not need each daily backup only the latest.
Can anyone help??