How do I copy, move, rename files from within the VBA code of my Access project?
How do I write a file backup routine into my Microsoft Access project/form?
'store a serial number in the parms table
'then read that serial number to +1 and name your backup file.
'then read that serial number to -5 to know which old backup file to delete.
'store FileName and FilePath in the Parms table as well
Dim rst As Recordset
Set rst = CurrentDb.OpenRecordset("Parms")
Dim BackupSerialNew As Integer
BackupSerialNew = rst!BackupSerial + 1
Dim strSQL_BackupSerial As String
strSQL_BackupSerial = "UPDATE