Hi,
I run the access tables back up every 4 hours. During that time i want to automatically close the access files from all the users. Presently i use the following which close only the forms, but the Querys linked with the forms are not getting closed. Could some one guide me, how to close the complete access files in the prefered time.
I am basic level user of access - Not expert in programs - Please help!!!
Private Sub Form_Timer()
ElseIf (Time() >= #10:45:00 AM# And Time() <= #11:55:00 AM#) Then
MsgBox "System Backup On-going.Please check back after 10 minutes."
DoCmd.Quit acQuitSaveAll
ElseIf (Time() >= #3:45:00 PM# And Time() <= #3:55:00 PM#) Then
MsgBox "System Backup On-going.Please check back after 10 minutes."
DoCmd.Quit acQuitSaveAll
End If
End Sub
I run the access tables back up every 4 hours. During that time i want to automatically close the access files from all the users. Presently i use the following which close only the forms, but the Querys linked with the forms are not getting closed. Could some one guide me, how to close the complete access files in the prefered time.
I am basic level user of access - Not expert in programs - Please help!!!
Private Sub Form_Timer()
ElseIf (Time() >= #10:45:00 AM# And Time() <= #11:55:00 AM#) Then
MsgBox "System Backup On-going.Please check back after 10 minutes."
DoCmd.Quit acQuitSaveAll
ElseIf (Time() >= #3:45:00 PM# And Time() <= #3:55:00 PM#) Then
MsgBox "System Backup On-going.Please check back after 10 minutes."
DoCmd.Quit acQuitSaveAll
End If
End Sub
