1

I have an MS Access database (2010) to which multiple users are connecting by using third party applications. Users are already requested to close applications using the database, but most of the users forgets. There is an overnight job runs every day that updates the database. As the database is busy, the update fails. Can someone help me with VBA script that checks if any users are connected and disconnect if there are any?

Regards

Shuja Umer
  • 21
  • 1
  • 2
  • 4
    Possible duplicate of [Force all users to disconnect from 2010 Access backend database](http://stackoverflow.com/questions/10905680/force-all-users-to-disconnect-from-2010-access-backend-database) – Comintern Sep 04 '16 at 14:01

1 Answers1

1

I use a hidden form which is loaded on starting the MS Access file. On this form I use the timer event checking something like:

If Hour(Now()) > 22 Then
   If Minute(Now()) > 50 Then
      Application.Quit
   End If
End If

If you are using AM und PM, you need to change "If Hour(Now()) > 22 Then" accordingly.

snibbo
  • 179
  • 11