PRIVATE mbIsRunning as boolean
Private Sub Form_Timer()
If txtStart = Now() And Not mbIsRunning Then
mbIsRunning = True
BackupDb
docmd.close
End If
sub BackupDb()
dim vSrc, vTarg, vName, vTime
vTime = format(now(),"yymmdd-hhnn")
vName = "MyDb-BE.accdb"
vSrc = "\\server\folder\"
vTarg = "\\server\backup folder\" & vTime & "_" & vName
Copy vSrc, vTarg
end sub