DELETE/KILL previous backups in specified folder

[craig1988]

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??

[ranman256]

1. NEVER delete backups
2.

vSrc = "\\server\folder\MyDb.accdb"
vTarg = "\\server2\folder2\GEIR_BACKUP_" & format(date,"yyyy_mm_dd") & "_MyDb.accdb"

Filecopy vSrc, vTarg

[ssanfu]

Agreed! I currently have 112 backups of the FE/BE.

The MINIMUM number of backups I would have at one time is 10 (two weeks if backed up daily). Then manually delete the oldest if more than 10 back ups.

You must not be aware of the 3 rules of computing:
The first rule is: Back up
The second rule is: Back up
and
You guessed it - the third rule is BACK UP.

I have a split database that is currently making a copy of the back end via an autoexec macro.

You are using an autoexec macro to make a copy of an open BE???
That is a recipe for disaster (corruption)!!. I would really be interested in exactly how you are doing the back ups.... if you care to share.

When I open the FE, it is linked to the BE. I can tell that the BE is open because I have two lock file: one for the FE and one for the BE. Copying the BE (or the FE for that matter) while it is open (active) is really dangerous.