how to gracefully close an access db on a shared folder

[OM]

Hi,

I have an access database that is shared by the network users. These
users tend to forget to close the applications when they finish their
work at the end of the day. This makes the server unable to backup the
file (being open). Can someone advice me how to gracefully close the
file when all users are longer using the db (even though their
application might still be open)?

Thanks

 

[Pieter Wijnen]

Put a Timer on a hidden form or switchboard

Sub Form_Timer()
If VBA.Timer > 72000 Then ' After 8 PM
Access.Application.Quit, acQuitSaveAll
End If
End Sub

HtH

Pieter